Dear Mazzaropi, You have pointed me in the right direction, Thank you for your prompt reply.

The report is working quite well:-)

Artytac
------------------------------------------------------------------

Dear Artytac, Good Morning.

You can use a simple COUNTIF FUNCTION.

Suppose your "Status" data are at D column.

Your report:
_______F_________G____________
4______AS________=COUNTIF(D2: D500,F4)
5______SM________=COUNTIF(D2: D500,F5)
6______SS________=COUNTIF(D2: D500,F6)
7______LS________=COUNTIF(D2: D500,F7)
8______LM________=COUNTIF(D2: D500,F8)


Tell me if it worked for you.

Feel free to ask anything about it.[/quote]