Sumif? not sure

[aclevela12]

Hi im looking to do a couple of what i think are simple formulas but with two criteria i cant seem to make it work
I have attached an example sheet, One sheet will just have essentially all the raw data i guess you could call it then another sheet will have the two boxes on the right. One for a daily stats and the month stats.
Basically im trying to figure out the formula to calculate the number of A at each specific time, once for the date listed and one just for the entire month.

 

[barry houdini]

I'm getting a message saying that your files contains a virus! Therefore I'm removing that link - please post a small sample of data to illustrate your problem

 

[MARZIOTULLIO]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[TD]

E​

[/TD]
[TD]

F​

[/TD]
[TD]

G​

[/TD]
[TD]

H​

[/TD]
[TD]

I​

[/TD]
[TD]

J​

[/TD]
[TD]

K​

[/TD]
[TD]

L​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]Date[/TD]
[TD]Time[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

2-Nov​

[/TD]
[TD]7:00 - 8:00[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Daily[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

2-Nov​

[/TD]
[TD]8:00 - 13:00[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Date Requested[/TD]
[TD]

2-Nov​

[/TD]
[TD]Total:[/TD]
[TD]

14​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

2-Nov​

[/TD]
[TD]13:00 - 18:00[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Time[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]

3-Nov​

[/TD]
[TD]7:00 - 8:00[/TD]
[TD]

1​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7:00 - 8:00[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

6​

[/TD]
[TD]

3-Nov​

[/TD]
[TD]8:00 - 13:00[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8:00 - 13:00[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[/TR]
[TR]
[TD]

7​

[/TD]
[TD]

3-Nov​

[/TD]
[TD]13:00 - 18:00[/TD]
[TD]

2​

[/TD]
[TD]

1​

[/TD]
[TD]

1​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]13:00 - 18:00[/TD]
[TD]

2​

[/TD]
[TD]

3​

[/TD]
[TD]

2​

[/TD]
[/TR]
[TR]
[TD]

8​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

9​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Monthly[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

10​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total[/TD]
[TD]

31​

[/TD]
[/TR]
[TR]
[TD]

11​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Time[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]

12​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7:00 - 8:00[/TD]
[TD]

2​

[/TD]
[TD]

4​

[/TD]
[TD]

4​

[/TD]
[/TR]
[TR]
[TD]

13​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8:00 - 13:00[/TD]
[TD]

4​

[/TD]
[TD]

3​

[/TD]
[TD]

3​

[/TD]
[/TR]
[TR]
[TD]

14​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]13:00 - 18:00[/TD]
[TD]

4​

[/TD]
[TD]

4​

[/TD]
[TD]

3​

[/TD]
[/TR]
</tbody>[/TABLE]

J5=SUMPRODUCT(($A$2:$A$7=$J$3)*($B$2:$B$7=$I5)*($C$1:$E$1=J$4)*($C$2:$E$7)) copy across and down

J12=SUMPRODUCT((MONTH($A$2:$A$7)=11)*(YEAR($A$2:$A$7)=2017)*($B$2:$B$7=$I12)*($C$1:$E$1=J$11)*($C$2:$E$7)) copy across

and down