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

MS EXCEL

### Next

• 1. Total Number of Hours
I have a tracking sheet and I entered the total number of hours spent on a project and then when I want the sume the total is 6.65 instead of 7.05 for 7 hours and 5 minutes. How do I fix this? The way I entered the time is 0.35 for 35 minutes. Do I need to enter the times a different way?
• 2. Finding User Id
Hi Some time ago I stumbled across some code in this group, that looks at wherever the computer stores the current user info and reports back with the user's ID. Trouble is, I've searched under every variation I can think of, but cannot find it. Does anyone know what I'm babbling about, and if so, can they point me in the right direction. Any help would be most appreciated. Steve
• 3. Time issues
OK, here is a strange time problem. I will try to make this as clear as I can as it is kind of confusing. For columns, I,J,L,M,N,P and S the format is "Custum" with a property of h:mm;@ Column R is set as currency. In columns I,J,L,M the user enters in time in the 24 hr clock format. (In this case, 23:58, 23:59, 00:05 and 00:11) The formula in Column 'N' is =SUM(M12-I12) If I enter in 1:58, 1:59, 2:05 and 2:11 (respectivly) column 'N' reads 0:13 as that is the time difference between M and I With the times I first said, 'N' reads ############# ANy ideas on how I can fix this problem? Thanks
• 4. Differences Tool
Does anyone know of a differences tool for comparing embedded VBA code between two .xls files for Excel 2002? Thanks, Scott

### 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?
```

### Re: 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

```

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

``` http://www.**--****.com/

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

a
do?

```

### Re: 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?

```

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

```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...
```

```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.

```

```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.
```

```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.