Forum Discussion
Excel Count Cells if another range contains a word
Hi, I need to add up the values from one row "IF" (looking upwards along a column) they're associated with a specific text from another row. For example, how do I calculate the sum of value...
Vicky285 The basic formula in B4 could be:
=SUMIF($G$2:$<col>$2,B$3,$G3:$<col>3)..... where you replace <col> with the letter of the last column in the ranges on rows 2 and 3. An example is attached.
Riny_van_Eekelen Oh wow, that works! Thank you so much for your help - I've been scratching my head on this for hours.
