To All that responded-

Thank you! The original reply was what I needed. It was my mistake-my
Column A did have #Value! error in it. I did not realize that it would cause
the problem. Once I added ISERROR, problem fixed!

Thanks again!

"Pete_UK" wrote:

Try these:

1:
=SUMPRODUCT((A1:A100=1)*(B1:B100="Yes")*(C1:C100=" Prime")*(ISNUMBER
(D1:D100)))

2:
=SUMPRODUCT((A1:A100=1)*(B1:B100="Yes")*(C1:C100=" Prime")*(D1:D100))

3:
=SUMPRODUCT((A1:A100=1)*(ISNUMBER(D1:D100)))

Hope this helps.

Pete


On Nov 9, 11:30 pm, Dave wrote:
I have a spreadsheet I use for sales management and need help with 3 formulas
I cannot figure out. Following is what I am trying to do:
1. If the value in cells A1:A100=1 and the value in cells B1:B100=Yes and
the value in cells C1:C100=Prime, count the cells in D1:D100 that have a
value in them. (column D contains numbers.)
2. Same as number 1 but instead of counting, sum the cells in D1:D100 that
have a value in them.
3. If the value in cells A1:A100=1, then count the cells in D1:D100 that
have a value in them. (column D contains numbers.)
Any help would be greatly appreciatied!

.