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
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
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