Sumproduct Function

A

arkieindc

Hi!

I am learning the SUMPRODUCT function, but need some help from mor
experienced users.

I am trying to write a formula that sums a third column of data whe
both criteria in two other columns are met. This is the formula that
have entered:

=SUMPRODUCT(--(EPM!A9:A215=A),--(EPM!B9:B215>="11"),EPM!AK9:AK215)

What am I doing wrong?

Any advice would be greatly appreciated!

Thanks!
DR
 
D

Domenic

arkieindc said:
*Hi!

I am learning the SUMPRODUCT function, but need some help from mor
experienced users.

I am trying to write a formula that sums a third column of data whe
both criteria in two other columns are met. This is the formula tha
I have entered:

=SUMPRODUCT(--(EPM!A9:A215=A),--(EPM!B9:B215>="11"),EPM!AK9:AK215)

What am I doing wrong?

Any advice would be greatly appreciated!

Thanks!
DRK *
Click to expand...

Hi,

In your first condition, the letter A should be enclosed withi
quotes.

In your second condition, the quotes around 11 is telling it to loo
for cells that contain 11 and that are formatted as text. So, i
you're actually looking for the number 11, then remove the quotes.

Hope this helps
 
Top