Thread
:
how do I add words, holiday =1, holiday am=0.5
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
how do I add words, holiday =1, holiday am=0.5
GCC,
Try:
=COUNTA(G1:G10)-SUM(--(RIGHT(G1:G10,2)={"AM","PM"}))/2
Array entered with Ctrl + Shift Enter
or
=COUNTA(G1:G10)-SUMPRODUCT(--(RIGHT(G1:G10,2)={"AM","PM"})/2)
Entered normally
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"GCC" wrote in message
...
I am trying to set up a holiday spreadsheet for work and I have got it so
it
adds up all the words holiday to say how many days each employee has taken
but I need to to add up the holiday AM and holiday PM as 0.5. Does anyone
know the formula to do this?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann