Sumproduct help? Please? :(

[excel_noob82]

Hi, i want to do a sumif but want to use two criterias


I have googled and used chandoo and come up with this


=SUMPRODUCT(--($B$4:$B$25="Composites"),--($F$4:$F$25="100%"),$H$4:$H$25)


But it just returns the value as zero, despite both criteria being met?


I also want to do the same but with "<100%)


Can anyone help?

 

[sgmpatnaik]

@Excel_noob


Hi


Please try this


=SUMPRODUCT(($B$4:$B$25="Composites")*($H$4:$H$25)*($F$4:$F$25<=100%))


Hope it will solve other wise please try to upload a sample workbook


Thanks


SP

 

[excel_noob82]

You are a top man, thank you very much!!

 

[sgmpatnaik]

@Excel_noob


Hi


Glad i solved your problem


welcome back if any problem


Thanks


SP

 

[Kevin@Radstock]

Hi


If your using Excel 2007 >. Then use the SUMIFS:


=SUMIFS(H4:H25,B4:B25,"Composites",F4:F25,"<100%")