Microsoft Outlook 2013 32/64-bit (mail m...

This is giving me fits! I keep trying to break this donw and now am just looking at this:

-----COUNTIF('2017 - RBB Productivity'!A:A,MONTH(2))

I was just trying to get Excel to tell me how many tasks were done in February. I get 0, which is not accurate.What I need it to do is this:

---SUMIF('2017 - RBB Productivity'!$A:$A,MONTH(2),'2017 - RBB Productivity'!B;B)A B C D Date High Med Low 2/17/17 3 1 2/20/17 5 2(I hope that table came out right!)

So for evey month of the year, I need to show how3 many H, M, L records were checked. Each date will have multiple entries so you might have 16 times that 2/1/17 is listed because each employee may do a High record.

Any ideas?

Do you want to countthe values by month orsumthe values by month?Should the answer for February/High be 8 (3+5) or 2 (for 2 dates in February)?

If 8, then look here:

https://exceljet.net/formula/sum-by...

If 2 then, try this:

=SUMPRODUCT(1*(MONTH(A3:A4)=2))

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

Ask Your Question

Weekly Poll