Sumif Help

[Ant]

I have a problem, I have a huge list and I need to sum
amounts up based on two criteria

First I need the formula to look in a cell and to see what
the user typed in it
Than the formula looks in between cells AM2:Am10000. Than
within that search do this formula
=SUMIF($AK$2:$AK10000,AV3,$O$2:$O10000)

Any ideas

I.E.

I have a magazine company. So first I have to see what
issue we are looking for


Than the specific story and see how much we spent on that
story

 

[Andy B]

Hi

I would suggest using SUMPRODUCT:

=SUMPRODUCT((AM2:AM10000=AV3)*(AN2:AN10000=criteria2)*(O2:O10000))

A couple of conditions: SUMPRODUCT cannot use full columns as criteria and
all ranges must be the same number of cells.

Hope this helps.

 

[Ant]

It's not working any other ideas?

-----Original Message-----
Hi

I would suggest using SUMPRODUCT:

=SUMPRODUCT((AM2:AM10000=AV3)*(AN2:AN10000=criteria2)* (O2:O10000))

A couple of conditions: SUMPRODUCT cannot use full columns as criteria and
all ranges must be the same number of cells.

Hope this helps.

--
Andy.





.

 

[Andy B]

What result are you getting? Can you post some sample data?