View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
alm09 alm09 is offline
external usenet poster
 
Posts: 7
Default sumif function by colors

Is there a way that I can sum up cells in column A by colors? For example,
suppose I have a list of numbers in cells A1:A15. Cells A1, A3, A5, and A10
are colored light yellow. I would like to see a number in cell B1 that sums
up all cells in A1:A15 that are colored light yellow.