Question on using Sumifs

Jesselynn

I'm trying to create a sheet that will calculate the sum of a referenced sheets based on a condition. The first column of the range is "status" and I want to report only "ongoing" statuses, the second column I want to use is "hard savings or soft" and only report "hard", and I'm trying to report the sum of the values in the "savings" column. Anyone know how to create this formula?

Antonio de Sousa

Hi,

I would use the Sheet Summary functionality and create a field with the COUNTIFS function for rows "Ongoing" and "Hard".

This is the function I used for the example below:

=COUNTIFS(Status:Status; ="Ongoing"; Savings:Savings; ="Hard")

Hope it helps.

Antonio