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

Similar Threads:

1.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?
> 

2.Sum Data in Col B, Add % of Total Col C, Add Rolling % of Total Co

Another challenge for a noob like me:

I start out with this, with the headers at Row 6:

Security	Value
Apples	10
Oranges	45
Dates	5
Pears	20
Weebles	1
Wobbles	1
MMA	1
MMB	3
MMC         1
	

Security	Value	% of Total	   % Rolling
Apples	10	11.5%	   11.5%
Oranges	45	51.7%	   63.2%
Dates	5	5.7%	   69.0%
Pears	20	23.0%	   92.0%
Other	2	2.2%	   94.3%
MM	5	5.7%	   100.0%
			
Total	87		

I tried to do this on my own but failed.  Here is what is tricky about this 
request:

1) Preference to insert formulas rather than to calculate and insert actual 
values -- I may have to add or delete data once the macro is one and leaving 
formulas in will provide me with that required flexibility.

2) Add the sum of Column B total at the bottom.

3)  There are a few cells that I have to add together and consolidate into 
one cell (MMA, MMB, MMC) and labled "MM."  This resulting summed figure 
should be hard-coded.  

These cells actually go by different names and sometimes there are 
differently labeled cells that I have to consolidate.  Ideally I can edit the 
macro to lookup cells that contain certain words (e.g., MMA, MMD, MMZ, MMF, 
MMJ) and consolidate into one cell and with one label "MM".

4)  Values less than 2% of the total value should be consolidated into one 
figure and labled "Other."

This is a tough one.  A macro I attempted to createy got derailed after 
summing column B (I obviously didn't get too far).  

Thanks very much for generously offering your time...

3.Sum Data in Col B, Add % of Total Col C, Add Rolling % of Tota

Thanks Bob.  But even I know how to do that.  My question is, is it possible 
to do all of this stuff, en total, with a macro?  Thanks very much.  

4.If Range has certain value, add corresponding value from other col

I have found numerous questions around this subject using dates, but none 
that match perfectly so I figured I'd ask the experts. 

I have a column of names repeating each day (Column B) and a column of how 
many samples were taken from that person on that day. (Column D) What I'm 
trying to do is say, "Every row that column b equals, "John Smith", sum the 
corresponding column d"

I can't figure out a way to do this using the IF or SUM statements. Any help 
would be appreciated. Thank you. 

5.Adding figures in excel if text is a certain colour

I have a spreadsheet with a lot of figures in it that 
evolves on a monthly basis. When the figures are added 
each month the figures are changed in colour from red to 
blue to denote going from budget costs to actual costs. I 
want excel to sum the figures based on colour. How can it 
be done. I have looked at the IF statement, but not sure. 
Thanks in advance Paul

6. Formatting cells in Excel for certain Values to appear certain Col

7. Can't figure out a certain column sort

8. sum only certain figures in the column