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

K

karen

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?
 
A

Anne Troy

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
 
P

Peo Sjoblom

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 said:
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
Click to expand...
do?
 
C

City Girl via OfficeKB.com

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?
 
K

karen

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
 
Top