| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally calculate formula in spreadsheet.
We have a sales spreadsheet that shows confirmed and projected sales. The
projected income from various items is shown in red in our spreadsheet, while confirmed sales are in black. My question is, can we create a formula at the bottom that automatically totals only the red coloured figures, leaving out the black, without having to click on each individual cell? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentage formula in Excel spreadsheet | New Users to Excel | |||
| Is it possible? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
