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
|