Summing based on format

[jennerifw]

OK, I have another one...

I have conditional formating turned on so once an item is marked as
completed, it's cell turns blue. Now I want to total the items that
have turned blue. Is there an easy way to do this?

 

[David McRitchie]

By using the same test as your Conditional Formatting uses.
and use of SUMPRODUCT or SUMIF

 

[Bob Phillips]

I think so, just use

=SUMIF(I13:AI13,">1")

adjust the range I13:AI13 to the range with the values.

 

[jennerifw]

I'm sorry for being so confused on this one.


When I use that formula I get the sum of the colum with the dates i
it, not the sum of the static values.

To break it down:

Colum F = static value
Colum I= date

Only some of Colum I have a date in them, so therefore only some o
Colum F are blue. At the bottom of colum F I want to total the blu
ones.

I appreciate all the help you've been giving me on this one