View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
april april is offline
external usenet poster
 
Posts: 111
Default subtotal colored cells

i used the pearson macro to add specifically colored cells. however, i have
a large spreadsheet and must add multiple ranges so i have to go to each
range and adjust the range that i want to add. the subtotal function is
perfect for setting the range, but it adds everything in the range and i only
want to add cells with a certain fill color in that range. tried this
SumByColor(SubTotal(9,H19:H22),35,false)) but got a VALUE error. Any
suggestions?

Thanks


--
aprilshowers