IF and SUM functions

[Paul]

Hi, I am struggling to make a formulae to sum based on other criteria. I have
the following formaulae that has been sufficient

=SUMIF(N26:N41,"x",$H$26:$H$41)

Now I need to expand this a little to add another criteria. in cells L26:41
I have a number between 0-100 and I want the above formaule ONLY to be
applicable to those INCLUDING AND ABOVE 70

I am hoping someone can help me here as I am sure it can not be hard but I
am struggling....

thanks

 

[Mike H]

Try

SUMPRODUCT((N26:N41="X")*(L26:L41>=70)*(H26:H41))

Mike

 

[Ashish Mathur]

Hi,

You may also try using the following array formula (Ctrl+Shift+Enter)

sum(if((N26:N41="X")*(L26:L41>=70),H26:H41))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com