Please can someone help me with a counting issue?
What is the formula I need to count the number of cells that contain "APPLES" AND "FRED"? Answer as above should be 3. Think I need a SUMPRODUCT formula, but can't come up with it.![]()
A B 1 APPLES FRED 2 APPLES FRED 3 APPLES FRED 4 APPLES BERT 5 APPLES BERT 6 LEMONS FRED 7 LEMONS FRED 8 BERRIES FRED 9 BERRIES FRED
Thanks!
Bookmarks