Hi

I have a spreadsheet which looks similar to below

Shift
D1
D1
D2
D4
N1
N4
M1

On a difference sheet, currently I add this up manually.
Is there a way that I can auto sum to give me a total using countif.

Days = 4
Mids = 1
Nights = 2

Thanks

Yogin