sumif & sumproduct

**sghellyer** · 10-29-2008, 03:42 PM

Can any one help with this one

i would to combined these together

can this be done

**VBA Noob** · 10-29-2008, 03:49 PM

Maybe

=SUMPRODUCT((A4:A24=C27)*(C4:C24)*(SUBSTITUTE(E4:E24,"-",0)))

VBA Noob

**sghellyer** · 10-29-2008, 03:58 PM

thanks alot

**cm115** · 02-06-2013, 04:44 PM

Hi,
This solution looks like it might be helpful for me....but not working entirely. Do I need to set it up as an array formula or something?

When I step into the formula, I see that the first term is evaluating the "if" criteria - it shows me an array of "true, true, false, etc", but is loks like it does not want to combine this with the subsequent two ranges.

Any guidance would be appreciated.

Thanks

Craig

Thanks

Craig