| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum a range that IS NOT NULL
Can someone help me with this.. I know it has to be easier than I am making
it for myself. I am trying to SUM a column contingent on another having a date entered in it (all on the same ROW). I am putting the sum in a colum off to the right of them both. I don't want to sum the rows without a date and the dates are always different. =IF(C3="date",I3*0.8,0) Something like this and I will be draggin this formula down Column "J", this is based on two columns the condition is the date, the dollars is in column "I" Please help!! -- JESSY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| replace null cells within a range to 0 | Excel Discussion (Misc queries) | |||
| COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
| Specify a null value in an Excel Database criteria range | Excel Worksheet Functions | |||
Threaded Mode
