I am trying to sum various cells within a worksheet. The HST values for various expenses. They are not all in the same row, column or section.
I was wondering if there was an easier method outside of the if(and(A1<>"",B7<>"" and so on.
The cells I need to sum are as follows:
IF(AND(c12<>"",h12<>"",h25<>"",h33<>""),C12+H12+H25+H33
And if one of is a blank cell it comes back as an error.
Any help would be appreciated. A friend suggested sumif with index match but I cannot see how that would work.
Thank you,
John
Bookmarks