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 posts
• Page **1** of **1**

- php
- Windows
- fortran
- MS WORD
- dotnet framework
- mysql
- windows ce
- Windows XP
- MS EXCEL
- WINDOWS SERVER

- 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

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?

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

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?

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?

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

4 posts
• Page **1** of **1**

Users browsing this forum: No registered users and 68 guest