U
UKMAN
Hi,
the layout is:
F1 throu AH1 are labeled as the days of a month i.e. 1,2,3 etc
F2 through AH2 show a "letter" catergory type i.e. B or S or H. for each
day(these are selected via a list)
F3 through AH3 show a "numeric ID" which is selected from a drop down list.
i.e. 2345. (there is many numeric ID's)
What I need to do is to sum the occurnace of each ID over the month i.e.
5xBx2345, 2xSx3456 etc so I can produce graphs.
All help welcome and many thanks in advance.
regards
Colin
the layout is:
F1 throu AH1 are labeled as the days of a month i.e. 1,2,3 etc
F2 through AH2 show a "letter" catergory type i.e. B or S or H. for each
day(these are selected via a list)
F3 through AH3 show a "numeric ID" which is selected from a drop down list.
i.e. 2345. (there is many numeric ID's)
What I need to do is to sum the occurnace of each ID over the month i.e.
5xBx2345, 2xSx3456 etc so I can produce graphs.
All help welcome and many thanks in advance.
regards
Colin