Sum multiple columns based multiple criteria

[vineet78]

Hi

I am struggling from last one week in applying one of the excel formula.
I have a spreadsheet having 10 columns of which last 4 are number columns.

Now based on criteria in first 6 columns , i need to sum total of last 4 columns.
Sum if and SUMPRODUCT both are not working.

Please help !

Regards
Vineet

 

[steve the fish]

You are a bit vague but try something like:

=SUMPRODUCT(--(A1:A10="a"),--(B1:B10="b"),--(C1:C10="c"),--(D1:D10="d"),--(E1:E10="e"),--(F1:F10="f"),G1:G10+H1:H10+I1:I10+J1:J10)

 

[vineet78]

Thanks Steve ! it worked for small range of data but will try it more my large workbook.
Also, another new issue i am facing is with SUMIF.
I have 4 sumifs formula say SUMIF1+SUMIF2+SUMIF3+SUMIF4 (All these sumifs have multiple criteria).
Now the real issue is that most of the times , my sum range is blank depending on period which i chose.
the result is that then particular SUMIF shows error >>#REF !
Then my combined UMIF1+SUMIF2+SUMIF3+SUMIF4 becomes #REF !
is there a way please to ignore #REF ! error and continue with rest of working please

thanks very much in advance for your help