| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF formula where the colour of the cell is the criteria
I have created a worksheet with a list of quotes that are either outstanding
or have produced a sale and I am using the good, bad and neutral styles to distinguish which is which, eg. a quote that has resulted in a sale is highlighted as 'good' (light green shading with a dark green font). I want a cell at the top of the sheet that adds all of the outstanding quotes together to show how much possible revenue is outstanding, I have tried using the SUMIF function but I dont know how to describe the cells when writing the formula so that it only adds the outstanding ones. help? :S |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif formula to calculate value of cell if certain criteria are m | Excel Worksheet Functions | |||
| Criteria Syntax in SUMIF formula | Excel Discussion (Misc queries) | |||
| SUMIF Formula w/ OR Criteria | Excel Discussion (Misc queries) | |||
| Sumif with 2 cell criteria | Charts and Charting in Excel | |||
| Can a formula be used in the Criteria field of SUMIF?? | Excel Worksheet Functions | |||
Threaded Mode
