E
eliyahuz
I have the following data
J K P
2 APRON Sony Camcorder Yes
3 Vivitar Digital Camera
4 APRON iHome iPod Dock Yes
5 APRON Vibrating Alarm Clock Yes
6 CAMERA Yes
7 camera Yes
8 Girl's Timex Watch
I want to count occurences of APRON in range (actually 7 columns like this
by 50 rows) ONLY if Yes appears in Column P.
I've tried COUNTIF, SUMIF, SUMPRODUCT and others but I can't get it right. I
either end up with errors (#VALUE) or the wrong sum. Any ideas?
J K P
2 APRON Sony Camcorder Yes
3 Vivitar Digital Camera
4 APRON iHome iPod Dock Yes
5 APRON Vibrating Alarm Clock Yes
6 CAMERA Yes
7 camera Yes
8 Girl's Timex Watch
I want to count occurences of APRON in range (actually 7 columns like this
by 50 rows) ONLY if Yes appears in Column P.
I've tried COUNTIF, SUMIF, SUMPRODUCT and others but I can't get it right. I
either end up with errors (#VALUE) or the wrong sum. Any ideas?