Re: Conditional Computing

Tech-Archive recommends: Fix windows errors by optimizing your registry

SUM them based upon the same condition that is applied to CF.

For instance, if the CF is greater than 10, then use

=SUMIF(A1:A10,">10")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


<aung@xxxxxxxxxxxx> wrote in message
news:1165931679.875819.99850@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I am not sure Excel 2003 can do this or not. Here is what I would like
to do.
I have a column (say column A) with some numbers. Some of the cells are
colored green and some are colored red.
I would like to add all the cells colored in red at cell B1 and add all
the cells colored in green at cell C1. The color may be changed
dynamically by means of conditional formatting.

Any idea?

Thanks.



.

Relevant Pages

  • Re: Alternate row colouring that also works when sheet is filtered?
    ... Since it was an empty worksheet, all the cells were empty. ... Close conditional formatting. ... row turns to alternate colouring. ... I can remember coming across in Excel. ...
    (microsoft.public.excel)
  • Re: Format Conditions Formula1
    ... Excel 2007 that the formula you see when you edit a rule is for the first ... works fine for all the cells. ... conditional formatting but now I am having trouble in Excel 2007. ... created a VB Macro that would evaluate each row and if there was no ...
    (microsoft.public.excel.programming)
  • Re: Simple SUMIF Question
    ... simple =sum() to add up the values in a column. ... I am an ASP.NET programmer trying to use a 3rd party product to produce Excel ... Actually the odd numbered cells such as E:5, ... I have a footer row in which I want to display the SUM of the odd numbered ...
    (microsoft.public.excel.misc)
  • Re: SUM, AVERAGE and PRINT with #N/A cells
    ... option in Excel 2000 may be different than what I posted. ... cells that contain #N/A to be the same as the background color of those ... brings results from another worksheet once I get some data for that month. ... wish to use the array formula, you can use the SUM function in the ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Sum of a column from nth row to end
    ... Microsoft Excel MVP ... UsedRange is, theoretically, the maximum range of cells in use (I said ... I know we can sum a whole column using SUMbut you cannot place ...
    (microsoft.public.excel.worksheet.functions)