SUMIF with multiple ranges

[betapiper]

So ive been using SUMIF to get a value from another sheet. That sheet has gotten a bit more complicated now and i want to get the value from 2 columns.

Gets the value from column H:H when it finds my K17 value in column in column C:C

=SUMIF(Estimate!C:C,K17,Estimate!H:H)​

No i want to get the value form both column H:H and D:D, is this possible with SUMIF or do i need to do a bunch of conditional testing?

Thanks

 

[AlphaFrog]

Try this...

=SUMIF(Estimate!C:C,K17,Estimate!H:H) + SUMIF(Estimate!C:C,K17,Estimate!D:D)