Formula to Count Entries

[hanidean]

Dear All,

Kindly help me with this issue. I am trying to count the entries as per month and number of entries which are out of SL (service level) and within SL(service level). I have the excel sheet attached and with an output in the bottom color coded.

Thanks,

[Fotis1991]

=sumproduct((month($e$4:$e$23)=month(d$27))*($i$4:$i$23<0))

=sumproduct((month($e$4:$e$23)=month(d$27))*($i$4:$i$23>=0))

??

[Pete_UK]

Put this in D28:

Please Login or Register  to view this content.

and this in D29:

Please Login or Register  to view this content.

Then copy both across into E28:E29. It sill give you 2, 9 and 2, 7 - note you have incorrectly colour-coded I12 as yellow.

Hope this helps.

Pete

[hanidean]

Thank you Fotis 1991 and Thank you Pete_UK. Both the formula's helped me. Much appreciated guys.

Hani

[Fotis1991]

........................

@ Pete

Welcome back!