Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match and count words | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
ADDITIONAL FIGURES IN COLUMN DON'T ADD TO TOTAL IN EXCEL | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How do I change location of figures within a column | Excel Worksheet Functions |