Adding up only the numbers that meet a specific criteria in another column

Calen Fitzsimmons

As stated in the titled above, I am trying to figure out how to do a formula that adds certain numbers together in a column, based on if the text in the column next to it, on the same row, is a certain value.

Example - Add Column B's Hours together (.5 +3 +6) but only if the column next to it in the same row says " Meetings".

Thanks for any and all advice/help!

Paul Newcome

You would want to look into the SUMIFS function.

=SUMIFS([Column to Sum]:[Column to Sum], [Criteria Column]:[Criteria Column], "criteria")

Paul Newcome

You would want to look into the SUMIFS function.

=SUMIFS([Column to Sum]:[Column to Sum], [Criteria Column]:[Criteria Column], "criteria")

Calen Fitzsimmons

Thank you Paul!

Thu Nghiem

Hi! Would this work the same for a COUNTIFS function? I want to count the number of rows that are not blank in one column when another column has a specific value.

Thank you!

Thu

Paul Newcome

@Thu Nghiem Yes it should.

=COUNTIFS([First Column]:[First Column], @cell <> "", [Second Column]:[Second Column], @cell = "specific value")