okiearcher
New Member
Hello!
First time poster here.
I'm sure it's simple to some, but I need to total the number portion of a range of cells where the cells might have numerical (leading portion) and alphabetic (trailing portion) value.
Example: Range of cells might be B2:M32
Some cells might contain values like "8 hrs FH" or "2 hrs FH" or "24 hrs FH".
Some other cells might contain values like "16 hrs VAC" or "40 hrs VAC", etc...
(without the quotes)
I need a formula that will total up all the numerical values from the cells that end with FH, and another formula that will total the numerical values of cell that end with VAC.
I could probably manage this with VBA, but I think formulas are more suited for this application.
Any help?
Thanks.
First time poster here.
I'm sure it's simple to some, but I need to total the number portion of a range of cells where the cells might have numerical (leading portion) and alphabetic (trailing portion) value.
Example: Range of cells might be B2:M32
Some cells might contain values like "8 hrs FH" or "2 hrs FH" or "24 hrs FH".
Some other cells might contain values like "16 hrs VAC" or "40 hrs VAC", etc...
(without the quotes)
I need a formula that will total up all the numerical values from the cells that end with FH, and another formula that will total the numerical values of cell that end with VAC.
I could probably manage this with VBA, but I think formulas are more suited for this application.
Any help?
Thanks.