View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
duketter duketter is offline
external usenet poster
 
Posts: 63
Default Can you sum cell amounts that are highlighted

Excel 2003 - I am trying to perform a sum for each row (A-Z) that have a cell
highlighted in yellow. So for example, cell A1, D1 and P1 may all be
highlighted in yellow. I want to then perform a sum of the numbers in these
cells only and display it.

Is this possible to sum the data in the cells that are highlighted?

Thanks!