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)
and
A (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?

Report •

#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. ;-)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


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
✔ Best Answer
The layout of your data does not make sense to me.

Since there are no Column letters or Row numbers, it's hard to figure out what data goes where. e.g. The "0" in your first table just seems to be hanging out between columns. The YTD in your second column also seems out of place.

Take look at my response. As you can see, it is very clear what data is in which Column and Row.

In addition, there are no values in your second table so I don't know what output you are expecting.

Please keep in mind that only you know your process and what you are trying to accomplish. We can't help unless you give us all of the details.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question