Count Monthly Data for a user (SUMPRODUCT?)

[phive_]

Hello all,
"Todays" Problem is that I’m trying to count total data (total count) that occurs in a month for a particular user (dynamic) in a sheet.

Data:
I have three columns on this particular sheet (we'll call it "RawData").
COL A: FortheWeekOf – Date of the last day of that week
COL B: AnaystsName – Analysts that handled the particular problem
COL C: CountOfID – Number Times that week that analyst handled a problem (total)

Example:
Fortheweekof | AnalystName | CountOfID |
Bob Smith | 05/13/2006 | 24 |
Bob Smith | 05/20/2006 | 29
Bob Smith | 07/06/2006 | 15 |
Bob Smith | 07/06/2006 | 45 |
John Doe | 05/13/2006 | 27 |
John Doe | 05/20/2006 | 19 |
John Doe | 06/20/2006 | 17 |
John Doe | 06/06/2006 | 11 |

So in the above data, on another sheet I would have:
Bob Smith: May = 2, June = 0, July = 2
John Doe: May = 2, June = 2, July = 0
(all in seperate cells of course)

I think a SUMPRODUCT would be used to do this, but for the life of me I can't figure it out.

 

[hatman]

Hah, hah. That was the solution I had originally proposed... From my original post :

Q10:

=SUMPRODUCT(--(L13:L20=O10),--(M13:M20>=DATE(YEAR(NOW()),MATCH(P10,{"January","February","March","April","May","June","July","August","September","October","November","December"},0),1)),--(M13:M20<DATE(YEAR(NOW()),MATCH(P10,{"January","February","March","April","May","June","July","August","September","October","November","December"},0)+1,1)),N13:N20)

Q11:

=SUMPRODUCT(--(L13:L20=O10),--(M13:M20>=DATE(YEAR(NOW()),P11,1)),--(M13:M20<DATE(YEAR(NOW()),P11+1,1)),N13:N20)

 

[Domenic]

Or, using Aladin's example...

=SUM(IF($A$2:$A$9=$E2,IF($B$2:$B$9-DAY($B$2:$B$9)+1=F$1,$C$2:$C$9)))

..confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

 

[phive_]

EXCELLENT!!

THANK YOU VERY MUCH

So I guess my bottle of advil can stay full for another day.

Thanks to every!

- Brian.