sum of same format cells

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

Hi
I am new to excel and I know how to sum cells, but how do
you sum cells with the same format, ie those with the
same background pattern in excel 2000.
thanks
 
Hi
not possible without using macros/VBA. So you'll need a
user defined function for this
 
Chip Pearson has information on working with cell colours:

http://www.cpearson.com/excel/colors.htm

However, if the cell colours represent another piece of information from
the row, e.g. Customer "ABC" has green cells, you could use SUMIF to
calculate the total: =SUMIF(A2:A100,"ABC",B2:B100)
 
Back
Top