Multiple criteria for sumif in Google Sheets

6
votes

I'm trying to calculate the sum of column in google spreadsheet when DataSheet!G:G="solved" AND DataSheet!C:C="May" it must calculate the sum of DataSheet!H:H.

I have tried 

=ARRAYFORMULA(SUM(((DataSheet!C:C)="May") * ((DataSheet!G:G)="solved") * (DataSheet!H:H) ))

But it returns N/A can anyone help me with this.

1
google-sheetsgoogle-sheets-formulaarray-formulas

1 Answers

3
votes

This formula would only returns N/A if a value on your H column is N/A. Have you checked that? And, are you sure it's N/A and not other kind of error?

If so, can you please share your spreadsheet, or a sample of it so I can take a look for myself, because I can't reproduce this.