Compound Functions
 

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

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?

Works Great!....

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

Thanks so much!

"Biff" wrote:

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?

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)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----