add total only shaded cells

I

israel

Hi everybody,

Can anyone help.
I have a formula that colors the cell which is less, how can I add only the
colored cells?

Example; Collumn "A" & Collumn "B" with 100 rows each, entered a formula
to highlight with a color the <cell. Is there a way to add the value of the
colored cell only?

Please help!
 
P

Per Jessen

Hi

You can not sum by color, but you can use a sumif formula, and apply
the you used to color cells

Your formula could look like this:

=SUMIF(A1:B100,"<100")

Regards,
Per
 
T

T. Valko

Try this:

=SUMPRODUCT(((A1:A100<B1:B100)*A1:A100)+((B1:B100<A1:A100)*B1:B100))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top