| 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 |
| 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) | |||
Threaded Mode
