Compound Functions

G

Greg Quick

=IF(AND($F$8:$F$100="",$E$8:$E$100="PCO"), SUM($G$8:$G$100), 0)

Returns 0 when it should a sum of numbers.
My Logic is:
When column f is blank and column E = "PCO" then sum column G.

What am I doing wrong?
 
B

Biff

Hi!

Try this instead:

=SUMPRODUCT(--(E8:E100="PCO"),--(F8:F100=""),G8:G100)

OR, use a cell to hold PCO:

A1 = PCO

=SUMPRODUCT(--(E8:E100=A1),--(F8:F100=""),G8:G100)

Biff
 
G

Greg Quick

Works Great!....

Now, how do I get a count based on the same conditions?

Thanks so much!
 
M

Max

Now, how do I get a count based on the same conditions?

Try: =SUMPRODUCT(--(E8:E100="PCO"),--(F8:F100=""))
(w/o the col G range)
 
Top