Counting/Summing rows based off of two different criteria

[KoolKatelyn]

Hello,

I'm looking for a formula that will count/sum up data in columns based off of the day of the week and what type is associated with an ID Number. The formula should count how many ID Numbers happened during a specific week day and separate the count by which type the ID Number is associated with.

I attached my Excel file to better display the end result that I am looking for.

[ChemistB]

It's a little tricky because you have merged cells for TYPE 1 and TYPE 2 but in G4

=COUNTIFS($A$2:$A$19, $F4,$B$2:$B$19, RIGHT(G$2,1)) copied down

In H4

=SUMIFS($D$2:$D$19,$A$2:$A$19, $F4,$B$2:$B$19, RIGHT(G$2,1)) copied down

[KoolKatelyn]

It's a little tricky because you have merged cells for TYPE 1 and TYPE 2 but in G4

=COUNTIFS($A$2:$A$19, $F4,$B$2:$B$19, RIGHT(G$2,1)) copied down

In H4

=SUMIFS($D$2:$D$19,$A$2:$A$19, $F4,$B$2:$B$19, RIGHT(G$2,1)) copied down

If the Type field is both variables and a number, how would I adjust the formulas to match that? (I attached an Excel file with the updated Type column). Would using an index/match formula be better?

[JohnTopley]

Try

=COUNTIFS($A$2:$A$19,$F4,$B$2:$B$19,G$2)

Replace RIGHT(G$2) with G$2

[KoolKatelyn]

Thank you both of you!! The formula is doing exactly what I need it to do!