VBA Problem. Trying to SUMIF the cell is a certain colour
Annual Leave Planner 2010.xlsmHello Everyone,
I desperately need some help with an excel sheet used to counting annual holidays and sickness. I have never used VBA before and whatever I have done is not working at all.
I have attached my sheet and I hope somebody will be able to help me.
Use the top 5 as an example (Rows 4-8)
In the red Column, I would like it to SUMIF the cells along the rest of the row are red.
In the green Colum, I would like it to SUMIF the cells along the rest of the row green,
I hope this makes sense. Red stands for holiday and green for sick. I just want totals of the amount of sick and holidays each person has taken.
Perhaps my F-Column is messing things up. It is supposed to be C+D-E if that makes sense. Sorry, I am pretty Clueless
Is there an easier way to do this? Or can someone help me please.
Thank-you very very much
Last edited by Ladyanna; 12-02-2009 at 10:26 AM.
It works for me..
What is the problem you are getting?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Do you actually color in your cells red or green yourself? If you do, you could automate your spreadsheet so that you input a letter (say "L" for leave and "S" for sick). Once you enter in your letter you could use conditional formats so that the cell automatically turns red or green, depending on the letter it finds.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks