add total only shaded cells
Try this:
=SUMPRODUCT(((A1:A100<B1:B100)*A1:A100)+((B1:B100< A1:A100)*B1:B100))
--
Biff
Microsoft Excel MVP
"israel" wrote in message
...
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!
--
smile
|