Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF FORMULA
Ron - very helpful just the sort of thing I was looking for.
One extra thing is that sometimes the shift will be referred to as UD as in 'Unrostered Days' similarly with the number of hours worked e.g UD8 ,UD10 etc. Potentially there could be even more characters before the number of hours e.g SSP (Shift Swap Payback) so I am looking for something that can deal with all the variations. I tried playing with the solution you sent but got #value error message. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF FORMULA
=SUM(IF(ISNUMBER(RIGHT($C$24:$C$388,2)*1),RIGHT($C $24:$C$388,2)*1,IF(ISNUMBE
R(RIGHT($C$24:$C$388,1)*1),RIGHT($C$24:$C$388,1)*1 ,0))) Entered with Ctrl+Shift+Enter should do what you describe. Regards, Tom Ogilvy Paul Bird wrote in message ... Ron - very helpful just the sort of thing I was looking for. One extra thing is that sometimes the shift will be referred to as UD as in 'Unrostered Days' similarly with the number of hours worked e.g UD8 ,UD10 etc. Potentially there could be even more characters before the number of hours e.g SSP (Shift Swap Payback) so I am looking for something that can deal with all the variations. I tried playing with the solution you sent but got #value error message. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF FORMULA
On Sun, 13 Jul 2003 12:40:03 -0700, Paul Bird wrote:
Ron - very helpful just the sort of thing I was looking for. One extra thing is that sometimes the shift will be referred to as UD as in 'Unrostered Days' similarly with the number of hours worked e.g UD8 ,UD10 etc. Potentially there could be even more characters before the number of hours e.g SSP (Shift Swap Payback) so I am looking for something that can deal with all the variations. I tried playing with the solution you sent but got #value error message. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! What Tom posted should work fine, so long as the shift hours are less than 100. --ron |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF FORMULA
not Less than 100; that would be a long shift. <g
Regards, Tom Ogilvy Ron Rosenfeld wrote in message ... On Sun, 13 Jul 2003 12:40:03 -0700, Paul Bird wrote: Ron - very helpful just the sort of thing I was looking for. One extra thing is that sometimes the shift will be referred to as UD as in 'Unrostered Days' similarly with the number of hours worked e.g UD8 ,UD10 etc. Potentially there could be even more characters before the number of hours e.g SSP (Shift Swap Payback) so I am looking for something that can deal with all the variations. I tried playing with the solution you sent but got #value error message. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! What Tom posted should work fine, so long as the shift hours are less than 100. --ron |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF FORMULA
Many Thanks Tom (& Ron) *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED | Excel Worksheet Functions | |||
Countif formula | Excel Discussion (Misc queries) | |||
COUNTIF formula | Excel Worksheet Functions | |||
Help with COUNTIF formula | Excel Discussion (Misc queries) | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions |