View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Nesting sumif functions

=SUMPRODUCT((A2:A1480="250")*(F2:F1480=25)*H2:H148 0)

It's probably a data consistency issue
(maybe text numbers/mix data are throwing things off)

Some guesses to get you going
Try these:
=SUMPRODUCT((A2:A1480=250)*(F2:F1480=25)*H2:H1480)
=SUMPRODUCT((A2:A1480="250")*(F2:F1480="25")*H2:H1 480)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---