Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help with SumIf
What am I doing wrong with this formula?
=SUMIF(L7:L7,"0",(L7*S7)) What I really want to do, is, if L7 has any value in it then I want to multiply this value by the value that is in S7. If there is no value (blank cell), then I want the cell that would contain the product to remain blank. L7 represents quantity S7 represents Cost Per Unit U7 represents Total When I try to multiply L7 to S7, I get errors. I amtrying to avoid having many cells with the 0 (zero) value |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help with SumIf
When I try to multiply L7 to S7, I get errors.
Do you mean that this formula gives you an error: =L7*S7 Does it return a #VALUE! error? If so, that means one of or both values are TEXT. Format those cells as GENERAL then select each cell and press function key F2 then hit ENTER. That should fix the error problem (unless there are unseen characters like spaces in one or both cells). What I really want to do, is, if L7 has any value in it then I want to multiply this value by the value that is in S7. =IF(ISNUMBER(L7),L7*S7,"") Biff "Ne0dammerung" wrote in message ... What am I doing wrong with this formula? =SUMIF(L7:L7,"0",(L7*S7)) What I really want to do, is, if L7 has any value in it then I want to multiply this value by the value that is in S7. If there is no value (blank cell), then I want the cell that would contain the product to remain blank. L7 represents quantity S7 represents Cost Per Unit U7 represents Total When I try to multiply L7 to S7, I get errors. I amtrying to avoid having many cells with the 0 (zero) value |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help with SumIf
Hi
SUMIF sums up values in one range when condition in another range is true - you have there not a range as 3rd argument at all, and more generally, you have only single cells in your formula - so no need for summing at all. =IF(OR(L7="",S7=""),"",L7*S7) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Ne0dammerung" wrote in message ... What am I doing wrong with this formula? =SUMIF(L7:L7,"0",(L7*S7)) What I really want to do, is, if L7 has any value in it then I want to multiply this value by the value that is in S7. If there is no value (blank cell), then I want the cell that would contain the product to remain blank. L7 represents quantity S7 represents Cost Per Unit U7 represents Total When I try to multiply L7 to S7, I get errors. I amtrying to avoid having many cells with the 0 (zero) value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How to use SUMIF function with non-adjacent cells | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) |