Ok, so here is my simple table, P1-P4 = Product, Ix = Ingredient +---------------------+ | A B C D | +---------------------+ | 1 P1 I1 I2 I3
I have an excel file with cells that retrieve data from a file stored on another computer. I need to update the file path in all of these formulas but it is ext
I have a column for age and a column for gender. How can I get the number of people with ages between 0-18 and with a gender of "male"? For example, with the fo
I have some data structured like this in an Excel spreadsheet: A B C D E F 1 1 1 2 x 2 3 2 1 1 1 2 2 3 3 3 3 3 3 4 4 I am trying to formulate an E
I am trying to figure out how to structure a countif formula. I have a table of data along with (broadly speaking) two sets of conditional formatting: - for the