Sumif based on 2 conditions

P

pkley

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
 
F

Frank Kabel

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
 
Top