Compound Functions

[Guest]

=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?

 

[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

 

[Guest]

Works Great!....

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

Thanks so much!

 

[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)