Thanks for your reply, but this formulae adds the different variations
of the data entered. I would just like numeric values to be counted as
1 occurence.
For example
m - 5.5
t - 6.6
w - 9.6
t JURY SERVICE
f - JURY SERVICE
I would just like the formulae to count this as once occurence, even
though 3 days have been entered.
Hope this makes sense
Thanks
Andrew
--
bsnapool
------------------------------------------------------------------------
bsnapool's Profile:
http://www.excelforum.com/member.php...o&userid=36115
View this thread:
http://www.excelforum.com/showthread...hreadid=559862