Sumif Help

  • Thread starter Thread starter Ant
  • Start date Start date
A

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





.
Click to expand...
 
Back
Top