Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Greetings!
I have the following columns: A. Cost B. Plan C. Additional D. Total $100.00 OTN $35 $135 OTN2 $40 $0 $150.00 OTN4 $25 $175 How can i get the TOTAL field to calculate Column A and C only when there is a value entered in Column A? In case you are wondering, the Additional Column (c) has assigned values, however I don't want a total if there isn't data in Column A? I hope you understand my msg. Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |