The syntax is
SumIf( range to filter by, criteria to filter, sum_range to be filtered)

In my case the first argument was a range in column B, my filter was "Male", and the range to actual sum was in column F.
=SUMIF($B$2:$B$641,"Male",F$2:F$461)

Since I was summing based on multiple items like "Male", I told Excel to use the column to the left to be my filter value.
=SUMIF($B$2:$B$641,$E649,F$2:F$461)
The criteria can be things like ">10".
No comments:
Post a Comment