how do i get a column to only add up the figures in a certain col
 

i have a column of fifures . some i want in red some in blue . i then want a
totall at the bottom of the red figures and blue figures . Is it easy to do?

how do i get a column to only add up the figures in a certain col
 

If you use color as your criteria, you will foreer be working around them.
Instead, create a column and put the value of Red or Blue in it. Then you
can far more easily sort, add, etc.
************
Anne Troy
www.OfficeArticles.com

"karen" wrote in message
...
i have a column of fifures . some i want in red some in blue . i then want
a
totall at the bottom of the red figures and blue figures . Is it easy to
do?

how do i get a column to only add up the figures in a certain col
 

http://www.cpearson.com/excel/colors.htm

you need to do some VBA for this

otherwise use the same criteria that you use when you colour them

=COUNTIF(A:A,criteria)


--

Regards,

Peo Sjoblom


"karen" wrote in message
...
i have a column of fifures . some i want in red some in blue . i then want
a
totall at the bottom of the red figures and blue figures . Is it easy to
do?

how do i get a column to only add up the figures in a certain col
 

Will there be a formula / criteria to determine which ones will be in blue
and which ones in red or are you just going to randomly choose figures for
colour?

karen wrote:
i have a column of fifures . some i want in red some in blue . i then want a
totall at the bottom of the red figures and blue figures . Is it easy to do?

how do i get a column to only add up the figures in a certain
 

i have a list of figures thats already generated from another report . i look
at it and code the red ones i want to pay , the blue ones i will pay next
week and so on . the report has about 6 months across the top so it needs to
be kept neat by not really adding colums in beside each months column

"City Girl via OfficeKB.com" wrote:

Will there be a formula / criteria to determine which ones will be in blue
and which ones in red or are you just going to randomly choose figures for
colour?

karen wrote:
i have a column of fifures . some i want in red some in blue . i then want a
totall at the bottom of the red figures and blue figures . Is it easy to do?