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

"Greg Quick" <Greg wrote in message
...
=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?