| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formula
is it possible to include and or exclude a number/cell from the result of a
formula based on format of cell? ie if the shading is anything other then no fill i want to not add it into toal but is it is no fill have it included in formula. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formula
There are VBA choices to choose from, if you search I'm sure you will find
it. However, if the shading is based on some condition, it is usually easier to just some based on the same conditions... -- ** John C ** "restes" wrote: is it possible to include and or exclude a number/cell from the result of a formula based on format of cell? ie if the shading is anything other then no fill i want to not add it into toal but is it is no fill have it included in formula. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formula
Chip Pearson has some notes (and a download) he
http://www.cpearson.com/excel/colors.aspx which explains all about counting and summing by colour. Hope this helps. Pete On Nov 7, 6:58*pm, restes wrote: is it possible to include and or exclude a number/cell from the result of a formula based on format of cell? ie if the shading is anything other then no fill i want to not add it into toal but is it is no fill have it included in formula. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formula
where would i search?
"John C" wrote: There are VBA choices to choose from, if you search I'm sure you will find it. However, if the shading is based on some condition, it is usually easier to just some based on the same conditions... -- ** John C ** "restes" wrote: is it possible to include and or exclude a number/cell from the result of a formula based on format of cell? ie if the shading is anything other then no fill i want to not add it into toal but is it is no fill have it included in formula. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formula
If you are accessing these groups from the Microsoft website, you could
search under Excel-- Programming. also, you might take a look at Pete's response. -- ** John C ** "restes" wrote: where would i search? "John C" wrote: There are VBA choices to choose from, if you search I'm sure you will find it. However, if the shading is based on some condition, it is usually easier to just some based on the same conditions... -- ** John C ** "restes" wrote: is it possible to include and or exclude a number/cell from the result of a formula based on format of cell? ie if the shading is anything other then no fill i want to not add it into toal but is it is no fill have it included in formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formula | Excel Worksheet Functions | |||
| conditional formula | Excel Discussion (Misc queries) | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
| Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Linear Mode
