ExcelBanter - Sum results from 2 columns that meet criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum results from 2 columns that meet criteria (https://www.excelbanter.com/excel-worksheet-functions/185908-sum-results-2-columns-meet-criteria.html)

Laura Larson

Sum results from 2 columns that meet criteria

Hi .. been trying to figure out formula for 2 days and can't seem to do it.

Would like excel to sum how many hires per month across several teams. I
currently have data in 2 columns, e.g.

Col A Col B
Team Month
DS May
GF April
DS April

how do I write the formula so excel will look at column A, then B and total
results per team per month.

Thank you!
--
Laura

Teethless mama

Sum results from 2 columns that meet criteria

=SUMPRODUCT(--(A2:A100="DS"),--(B2:B100="May")

"Laura Larson" wrote:

Hi .. been trying to figure out formula for 2 days and can't seem to do it.

Would like excel to sum how many hires per month across several teams. I
currently have data in 2 columns, e.g.

Col A Col B
Team Month
DS May
GF April
DS April

how do I write the formula so excel will look at column A, then B and total
results per team per month.

Thank you!
--
Laura

All times are GMT +1. The time now is 08:00 AM.