Sum if

  • Thread starter Thread starter ant
  • Start date Start date
A

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 o2:o10000

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 #
 
Untested
=SUMPRODUCT((AK2:AK10000=AV3)*(AO2:AO10000=AV4)*AM2:AM10000=AV5)*(O2:O10000)
)
Regards,
 
Hi
not sure about your specification but try
=SUMPRODUCT(--(AK2:AK10000=AV3),--(AO2:AO10000=AV4),--(AM2:AM10000=AV5)
,O2:O10000)
 
Back
Top