Sum if

[ant]

Does anyone know why this forumla isnt working.
=SUM(IF((AK2:AK10000,AV3)*(AO2:AO10000,AV4)*
(AM2:AM10000=AV5),O2:$O10000))
It looks in 3 cells and adds everything based on whats
in those cells

Sums everything in rang o210000

but i want it to only add what the user inputs in those 3
cells

AV3 should be a #

Av4 should be text

Av5 should be #

 

[Alan]

Untested
=SUMPRODUCT((AK2:AK10000=AV3)*(AO2:AO10000=AV4)*AM2:AM10000=AV5)*(O2:O10000)
)
Regards,

 

[Frank Kabel]

Hi
not sure about your specification but try
=SUMPRODUCT(--(AK2:AK10000=AV3),--(AO2:AO10000=AV4),--(AM2:AM10000=AV5)
,O2:O10000)