Sumproduct Function

[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

 

[Domenic]

*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 *

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

 

[arkieindc]

That did the trick! Thank you so much

 

[Domenic]

*That did the trick! Thank you so much! *

You're very welcome