Adding cells that have varying contents
Have a group of cells in a row that all contain similar formulas.
They look like: =IF(T17="","",T17*($M17/$N17)) or, =IF(U17="","",U17*($M17/$N17)) I want to add up the results of their formulas, including the cells that have returned blanks. If 8 columns have this (or similar) formula, and only 2 display numbers, how can I return a true sum, that is not" #VALUE" as a total for that row? TIA for any help. Pierre |
Adding cells that have varying contents
One way:
=SUM(T17:AA17) SUM() ignores text.In article . com, Pierre wrote: Have a group of cells in a row that all contain similar formulas. They look like: =IF(T17="","",T17*($M17/$N17)) or, =IF(U17="","",U17*($M17/$N17)) I want to add up the results of their formulas, including the cells that have returned blanks. If 8 columns have this (or similar) formula, and only 2 display numbers, how can I return a true sum, that is not" #VALUE" as a total for that row? TIA for any help. Pierre |
Adding cells that have varying contents
maybe =sumif(A1:h25,"<""",a1:h25)
-- JNW "Pierre" wrote: Have a group of cells in a row that all contain similar formulas. They look like: =IF(T17="","",T17*($M17/$N17)) or, =IF(U17="","",U17*($M17/$N17)) I want to add up the results of their formulas, including the cells that have returned blanks. If 8 columns have this (or similar) formula, and only 2 display numbers, how can I return a true sum, that is not" #VALUE" as a total for that row? TIA for any help. Pierre |
Adding cells that have varying contents
On Sep 11, 5:14 pm, JNW wrote:
maybe =sumif(A1:h25,"<""",a1:h25) -- JNW "Pierre" wrote: Have a group of cells in a row that all contain similar formulas. They look like: =IF(T17="","",T17*($M17/$N17)) or, =IF(U17="","",U17*($M17/$N17)) I want to add up the results of their formulas, including the cells that have returned blanks. If 8 columns have this (or similar) formula, and only 2 display numbers, how can I return a true sum, that is not" #VALUE" as a total for that row? TIA for any help. Pierre- Hide quoted text - - Show quoted text - I should have been more specific: The range containing the formulas are in a row, but the formulas I want totaled are in "every other column"; =SUM(T17:AA17) ,a SUM with a contiguous range won't total the cells as needed. Couldn't get the SUMIF as noted above to work either. T17+V17+X17 etc. Those cells contain the formula, and we're after a total of those in column Y. Thanks again for a second look. Pierre |
Adding cells that have varying contents
=SUMPRODUCT(--(MOD(COLUMN(T17:AA17),2)=0),T17:AA17)
"Pierre" wrote: On Sep 11, 5:14 pm, JNW wrote: maybe =sumif(A1:h25,"<""",a1:h25) -- JNW "Pierre" wrote: Have a group of cells in a row that all contain similar formulas. They look like: =IF(T17="","",T17*($M17/$N17)) or, =IF(U17="","",U17*($M17/$N17)) I want to add up the results of their formulas, including the cells that have returned blanks. If 8 columns have this (or similar) formula, and only 2 display numbers, how can I return a true sum, that is not" #VALUE" as a total for that row? TIA for any help. Pierre- Hide quoted text - - Show quoted text - I should have been more specific: The range containing the formulas are in a row, but the formulas I want totaled are in "every other column"; =SUM(T17:AA17) ,a SUM with a contiguous range won't total the cells as needed. Couldn't get the SUMIF as noted above to work either. T17+V17+X17 etc. Those cells contain the formula, and we're after a total of those in column Y. Thanks again for a second look. Pierre |
Adding cells that have varying contents
On Sep 11, 8:08 pm, Teethless mama
wrote: =SUMPRODUCT(--(MOD(COLUMN(T17:AA17),2)=0),T17:AA17) Thank you Teethless!! Pierre |
All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com