Try this then
=SUMPRODUCT(--ISNUMBER(F12:L12),(F12:L120)/COUNTIF(F12:L12,F12:L12&""))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"bsnapool" wrote in
message ...
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