Excel formula.
Moderator: Moderators
- DennisH
- Anorak Extraordinaire
- Posts: 797
- Joined: Tue Feb 20, 2007 3:21 pm
- 17
- Industry Sector: Retail Distribution/Manufacturing
- Occupation: Regional Health & Safety Manager
- Location: west yorkshire
Excel formula.
Here again for help,
I am struggling with a formula and hoped that there is someone out there who can help.
I want to count column A in Column C every time it has a Value, I also want to add column B when A & B has a value, however if cell B has a Value but A does not I want to lave cell C empty. does anyone have any ideas ?
I have attached where I am up to at moment. any assistance as always is gratefully received.
Thanks
I am struggling with a formula and hoped that there is someone out there who can help.
I want to count column A in Column C every time it has a Value, I also want to add column B when A & B has a value, however if cell B has a Value but A does not I want to lave cell C empty. does anyone have any ideas ?
I have attached where I am up to at moment. any assistance as always is gratefully received.
Thanks
- Attachments
-
- Data.xls
- (18.5 KiB) Downloaded 676 times
Re: Excel formula.
Hi Dennis,
From the spread sheet you provided, I believe that the formula you want in Cell 'C' is:
=IF(A3="","",(SUM(A3,B3)))
This checks if Cell A has a value, and if not, leaves Cell C blank.
If Cell A has a value then it adds Cell A to Cell B.
Please send me a pm if you have any questions on this.
Regards
Adrian
From the spread sheet you provided, I believe that the formula you want in Cell 'C' is:
=IF(A3="","",(SUM(A3,B3)))
This checks if Cell A has a value, and if not, leaves Cell C blank.
If Cell A has a value then it adds Cell A to Cell B.
Please send me a pm if you have any questions on this.
Regards
Adrian
- YoungNick
- HSfB Moderator
- Posts: 2390
- Joined: Thu May 13, 2010 9:33 pm
- 13
- Industry Sector: CDM - Rail - Telecoms
- Occupation: Group Health and Safety Officer.
Attainments: NGC, NCC, FCC, NDIP (H&S), SMSTS - GradIOSH. - Has thanked: 1 time
- Been thanked: 4 times
Re: Excel formula.
How do you all manage to learn excel tools and formulas? I get so caught up on excel in work, i wish i could do some of the things above and even more...
Hope for the best, but prepare for the worst.
A big thank you to all the members here at HSfB.
A big thank you to all the members here at HSfB.
- ShaneJ
- Snr Member
- Posts: 413
- Joined: Wed Dec 05, 2012 4:00 pm
- 11
- Industry Sector: Food Processing
- Occupation: H & S Manager
- Has thanked: 2 times
- Been thanked: 2 times
Re: Excel formula.
I found Excel to be really difficult until I was thrown into it, needing to create a spreadsheet for training with conditional formatting for dates, percentages of staff trained, etc. and different training and periods for refresh.YoungNick wrote:How do you all manage to learn excel tools and formulas? I get so caught up on excel in work, i wish i could do some of the things above and even more...
Finally managed it with lots of help from Google but it needed hidden cells and resulted in lots of pulling of hair (as shown to the right).
Stick with it and feel free to ask if, like Dennis, you have a particular problem.
Life is like a game of cards. The hand that is dealt you represents determinism; the way you play it is free will.
Re: Excel formula.
Nick,
I learnt the majority of it the hard way, by trial and error, and using the help system in Excel, but it is worth pursuing if you have a specific task.
As Shayne has said, if you have any questions, please post them here, or feel free to drop me a pm, but I don't normally manage to get onto the site until late on in the day (due to working a late shift), so it may be a while before I pick up the post or message.
Regards
Adrian
I learnt the majority of it the hard way, by trial and error, and using the help system in Excel, but it is worth pursuing if you have a specific task.
As Shayne has said, if you have any questions, please post them here, or feel free to drop me a pm, but I don't normally manage to get onto the site until late on in the day (due to working a late shift), so it may be a while before I pick up the post or message.
Regards
Adrian
Re: Excel formula.
ShaneJ,
What you mentioned there is exactly what I am trying to do right now. I don't suppose you know of any youtube tutorials that explains this?
Cheers
Will
What you mentioned there is exactly what I am trying to do right now. I don't suppose you know of any youtube tutorials that explains this?
Cheers
Will
- jonsi
- HSfB Moderator
- Posts: 1866
- Joined: Wed Oct 14, 2009 4:34 pm
- 14
- Industry Sector: Polymer Processing
- Location: Sunshiny North Wales
- Has thanked: 1 time
- Been thanked: 2 times
Re: Excel formula.
Will ...send me a PM with what you're trying to achieve and an email addy and I'll see if I can help.
Jonsi
Jonsi
.
"Talk about Mental Illness - because it will touch your life this year. "
"Talk about Mental Illness - because it will touch your life this year. "
- witsd
- Grand Shidoshi
- Posts: 1086
- Joined: Tue Nov 18, 2014 4:37 pm
- 9
- Occupation: Fire safety officer
- Location: Glasgow
- Has thanked: 90 times
- Been thanked: 264 times
Re: Excel formula.
Half-decent MS Excel skills are a very useful skill to have. They can be a massive timesaver in the long run, and are well worth learning.
I've got friends who have completed courses on Excel, but personally I've just picked up bits as I've needed them, usually starting with an 'I wonder if it can…?' thought, and resulting in about 5 minutes of research to confirm that it can and then about 2 hours of messing about to work out where my missing speech mark of bracket is.
The help function should be your first go-to. Help functions have traditionally been next to useless, but they've gotten a lot better. Failing that, a Google search will find what you are looking for (providing you can describe it!) in no time.
I've got friends who have completed courses on Excel, but personally I've just picked up bits as I've needed them, usually starting with an 'I wonder if it can…?' thought, and resulting in about 5 minutes of research to confirm that it can and then about 2 hours of messing about to work out where my missing speech mark of bracket is.
The help function should be your first go-to. Help functions have traditionally been next to useless, but they've gotten a lot better. Failing that, a Google search will find what you are looking for (providing you can describe it!) in no time.
We often think that when we have completed our study of one we know all about two, because 'two' is 'one and one.' We forget that we still have to make a study of 'and.'