combo forumla help

[ant]

Hello every one.

I need a function that works like a pivot table would.

I have a huge worksheet with over 10000 entrees in it

Now I need the function to look at three cells, based on
what the user types I need the function to add a few
columns

In cell A1, the user types in the year (2003) than the
function look through columns AL1: Ak10000 than adds
everything in range o210000
This function works great

SUMIF($AK$2:$AK10000,A1,$O$2:$O10000)

However I also want the function to look at cell B5 and
see what month was type in

So the function would only add (for example) January 2003


And finally one more criteria,

Look in cell c5 for the account the user types in (for
example) "21210" so it will add only the 21210 account
for January 2003
Any ideas?

 

[ant]

SUM(IF(($AK$2:$AK10000,AV3)*($AO$2:$AO10000,AV4)*
($AM$2:$AM10000=AV5),$U$2:$U499))

 

[Frank Kabel]

Hi
use SUMPRODUCT for this. Lets assume your user type in in column AJ and
column AL stores the month name as text then use
=SUMPRODUCT(--(AL1:AL10000=B5),--(AK1:AK10000=A1),--(AJ1:AJ10000=C5),O2
:O10000)