I tried the function =SUMPRODUCT(--(ColorIndex(A1:A100)=3),A1:A100) to sum
colored cell but when i enter this funtion it gives value as #NAME? kindly
help to solve
Regards
"Bob Phillips" wrote:
You need VBA
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"viraj" wrote in message
...
A B
1 x 3
2 y 2
3 z 4
If I fill color (Red) B1 and B3 then I should get the sum of B1 and B3.
How this function can be made in excel with the property of cell?