Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and colored cell as a condition to be met
can a colored cell be used as a condition for an argument? If so, how is it
written in the formula? thanks, George P. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and colored cell as a condition to be met
Well, colored cells can be used as conditions in macros, but not in built-in
Excel functions. See, for example, here, for how to sum and count by cell color: http://www.ozgrid.com/VBA/Sum.htm Dave -- Brevity is the soul of wit. "George P" wrote: can a colored cell be used as a condition for an argument? If so, how is it written in the formula? thanks, George P. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and colored cell as a condition to be met
See http://xldynamic.com/source/xld.SUMPRODUCT.html
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "George P" wrote in message ... can a colored cell be used as a condition for an argument? If so, how is it written in the formula? thanks, George P. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
another sumproduct question | Excel Worksheet Functions |