How many of this type on Mondays

[camiloq]

Hello there,

When I run a report for my company I get a file that contains 3 columns
Date, employee and Shift

I need to find out how many of each type happened on monday, tuesday, etc.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Employee[/TD]
[TD]Shift[/TD]
[/TR]
[TR]
[TD]Aug 8, 2016[/TD]
[TD]Bob[/TD]
[TD]Classic[/TD]
[/TR]
[TR]
[TD]Aug 8, 2016[/TD]
[TD]Sally[/TD]
[TD]Mini[/TD]
[/TR]
[TR]
[TD]Aug 8, 2016
[/TD]
[TD]John[/TD]
[TD]Classic
[/TD]
[/TR]
[TR]
[TD]Aug 9, 2016[/TD]
[TD]John[/TD]
[TD]Classic[/TD]
[/TR]
[TR]
[TD]Aug 10, 2016[/TD]
[TD]John[/TD]
[TD]Admin[/TD]
[/TR]
[TR]
[TD]Aug 11, 2016[/TD]
[TD]Sally[/TD]
[TD]Classic[/TD]
[/TR]
</tbody>[/TABLE]

I would like to know, how many Classic shifts happened on Monday. I am using
=SUMPRODUCT(--(WEEKDAY($A$2:$A$1000)=2))
which gives me how many monday shifts there are, but I need it to be Classic shifts on Mondays, and I don't know how to add that second condition. I could also use all shifts except for admin if that formula would be easier

Thanks for the help.

 

[Caleeco]

Hello,

Does this work for you?

=SUMPRODUCT(--(WEEKDAY($A$2:$A$1000)=2),(--($C$2:$C$1000="Classic")))

More info on SumProduct here:
https://exceljet.net/excel-functions/excel-sumproduct-function

Let me know if it works
Thanks
Caleeco

 

[camiloq]

That works, I have tried that but didn't add --( ) , what does that do anyway?

 

[T. Valko]

Take a look at these links...

http://xldynamic.com/source/xld.SUMPRODUCT.html

McGimpsey & Associates : Excel : Formulae : Why "--"