# Solved Only count cells if the date is March?

Microsoft Outlook 2013 32/64-bit (mail m...
March 21, 2017 at 11:53:37
Specs: Windows 64
 I have a worksheet where I need a tally of who is doing what during a certain month.In this case, A is the date, B is the person, C-D-E are the types of tasks.So if A (3/2/17) is in March and B (Joe Blow) worked C (3 Triggers) and D (2 Events) andA (3/15/17) is in March and B (Joe Blow) worked C (4 Triggers) and D (6 Events) and E (1 New)then March's worksheet would show F (Joe Blow) G - total (16) with H - Triggers (7) and I - Events (8) and J - New (1)Does that make sense?

See More: Only count cells if the date is March?

#1
March 21, 2017 at 12:35:54
 If I understand your post correctly, you have this:``` A B C D E F G H I J 1 Date Name Triggers Events New Name Total Triggers Events New 2 3/2/17 Joe Blow 3 2 Joe Blow 3 3/15/17 Joe Blow 4 6 1```Put this in H2 and drag it across to J:=SUMPRODUCT((MONTH(\$A\$2:\$A\$3)=3)*(\$B\$2:\$B\$3=\$F\$2)*(C2:C3))I'm sure that you can figure out the SUM formula for Column G. ;-)

Report •

#2
March 21, 2017 at 14:19:46
 I think I simplified my example too much. Here's some of my data:```Date ANALYST NAME Top Periodic Trigger Event New to Bank & New Product 3/6/2017 Joe 1 6 1 3/6/2017 Joe 2 3 3/6/2017 Joe 3 4 3/6/2017 Joe 4 1 0 1 3/6/2017 Joe 5 ``` And then on a ws called Totals I'd have the breakdown, which looks like this:```By Analyst All Reviews Periodic Trigger NTB/NP YTD Joe 1 Joe 2 Joe 3 Joe 4 Joe 5 ```The next table would have the breakdown for just the types of reviews each month. Figuring out the month and getting the sum instead of just a 1 is getting me. I have 15 employees total and each of them have a line of data per workday with how many types of each task they do.

Report •

#3
March 21, 2017 at 16:17:21