Sumif based on 2 conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one (A) column with 1-12 (for month) with a varying number of rows per month. (B) contains Initials of Technicians, (C) contains Net Sales $. I then have a cell for each Tech each month. I need the sum of C:C that each tech did each month. What formula should I use or should I use a Macro? The rows vary because each row is a different job in a large spreadsheet that is being filtered different ways
Month Tech
1 PRK 380
1 CXF 540
1 PRK 290
2 PRK 500
2 PRK 430
2 CXF 12000
 
Hi
you can use SUMPRODUCT to calculate the sum for each tech per month.
Try the following (assuming row 1 is a heading row)
=SUMPRODUCT((A2:A999=1)*(B2:B999="PRK"),C2:C999)
this will calculate the sum for technican 'PRK' in the first month

HTH
Frank
 

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

Summary Worksheet. 1
Conditional Format based on dates 3
Excel Getting an annualized figure based on YTD in Excel 1
Sumif 2
sumif with summed columns 3
Countif or sumif for cumulative sums,pivot table & chart 2
Column Heading on each row in pivot table 1
Conditional formatting 3

Back
Top