Try something like this:

With
A1:F1 containing any values, including "H" and "h" values

This formula counts each "H" as 1 and each "h" as 0.5 then sums those values.
G1: =SUMPRODUCT(EXACT(A1:F1,"H")+EXACT(A1:F1,"h")*0.5)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Suza" wrote:

Looking to use 'h' in an attendance record to denote 1/2 day's holiday taken,
then the 'H' denotes a whole day

How would this be possible? Can't see how to get the function to recognise
'h' as being different to 'H' in order to use a function