View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default subtotal colored cells

I think your formula should be:

SumByColor(H19:H22,35,false)

The first parameter is the range you want to sum, and the second
parameter is the colour number.

Hope this helps.

Pete

On Dec 7, 3:25 pm, april wrote:
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