Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum cells that have values from a text formula?
How do I sum cells that have values from a text formula?
I have a row of this formula: =TEXT(D6-D5,"h") The only difference in the cells of the row are the referring cells. When I sum them up, and just get a 0. So I figure I have to use a formula that counts the resulting values of other formulas, but I cannot find it in the help system. =SUM(B7:H7) <---- results in a 0 no matter what the values of the cells are. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum cells that have values from a text formula?
Hi,
Let's say the formula to sum are in a1 & B1, try this =SUMPRODUCT(A1:B1+0) Extend the range A1:B1 as required -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DigESource" wrote: How do I sum cells that have values from a text formula? I have a row of this formula: =TEXT(D6-D5,"h") The only difference in the cells of the row are the referring cells. When I sum them up, and just get a 0. So I figure I have to use a formula that counts the resulting values of other formulas, but I cannot find it in the help system. =SUM(B7:H7) <---- results in a 0 no matter what the values of the cells are. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum cells that have values from a text formula?
Thank you very much Mike. You have relieved my headache from this. Better
than prescription medication. Darin "Mike H" wrote: Hi, Let's say the formula to sum are in a1 & B1, try this =SUMPRODUCT(A1:B1+0) Extend the range A1:B1 as required -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DigESource" wrote: How do I sum cells that have values from a text formula? I have a row of this formula: =TEXT(D6-D5,"h") The only difference in the cells of the row are the referring cells. When I sum them up, and just get a 0. So I figure I have to use a formula that counts the resulting values of other formulas, but I cannot find it in the help system. =SUM(B7:H7) <---- results in a 0 no matter what the values of the cells are. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum cells that have values from a text formula?
Glad i could help and thanks for the feedback
-- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DigESource" wrote: Thank you very much Mike. You have relieved my headache from this. Better than prescription medication. Darin "Mike H" wrote: Hi, Let's say the formula to sum are in a1 & B1, try this =SUMPRODUCT(A1:B1+0) Extend the range A1:B1 as required -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "DigESource" wrote: How do I sum cells that have values from a text formula? I have a row of this formula: =TEXT(D6-D5,"h") The only difference in the cells of the row are the referring cells. When I sum them up, and just get a 0. So I figure I have to use a formula that counts the resulting values of other formulas, but I cannot find it in the help system. =SUM(B7:H7) <---- results in a 0 no matter what the values of the cells are. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I sum cells that have values from a text formula?
"DigESource" wrote in message ... How do I sum cells that have values from a text formula? I have a row of this formula: =TEXT(D6-D5,"h") The only difference in the cells of the row are the referring cells. When I sum them up, and just get a 0. So I figure I have to use a formula that counts the resulting values of other formulas, but I cannot find it in the help system. =SUM(B7:H7) <---- results in a 0 no matter what the values of the cells are. Mike's answer is the best, but it might be fun to try =IMSUM(B7:H7) The result will still be text hours. Hans T. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find max value from 3 cells, return text, but 2 max values same! | New Users to Excel | |||
Unable to sum the specific cells containing both text & values | Excel Worksheet Functions | |||
Assign Values to text cells | Excel Discussion (Misc queries) | |||
NON-TEXT VALUES IN CELLS | Charts and Charting in Excel | |||
Display text depending on values of 3 different cells? | Excel Worksheet Functions |