Sum results from 2 columns that meet criteria

L

Laura Larson

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum cells based on contents of adjacent cell (validated list)? 3
Sumif with more than one criteria 15
create new table from Multiple Criteria in multiple columns 3
Sum total using Sumproduct if two criteria met 5
using sumifs to sum based on month, and criteria 13
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year) 2
sum, lookup, and date range 1
Sum on multiple columns with search criteria 6

Top