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.
You need to use SUMIFS function that is by default designed to sum numbers with multiple criteria, based on AND logic. You can also use SUMIFS function to sum number with multiple criteria, based on OR logic, with an array constant.
Using Excel SUMIFS Function To Sum Values With Multiple Criteria. You have to use the SUMIFS function in Excel to sum values with multiple criteria, as the SUMIF function can handle only one criterion at a time.
In Google Sheets, the COUNTIF function accepts only one data range and one criterion.
Google Sheets SUMIF to sum a data range on a condition SUMIF is a Google Sheets function to return a total of cells that match a single specific criterion. Put simply, the SUMIF function filters the range according to the specified criteria and sums values based on this filter. The syntax is the same as SUMIF Excel.
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With