Excel 2003 - Need Formula Help

W

windsong

I would like some help with a formula. I am using a spreadsheet to track
paid time off. I have the different kinds of time off in the cells in
different colors. For example: red=vacation; green=company holiday; blue=FMLA.

Each employee has one row.

At the end of the row, I need to take a total for each color. I need the
formula to be something like - if green, count 1, if not, zero, etc. What
would the formula be?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 0
Mail Merge Help 1
Standard Deviation and Averages based on criteria 2
Need to reorganize - transpose columns to rows per article number 1
need help with excel 2
Assigning a value to one cell based on the date in another... And then doing it again 0
More than 3 conditional statements or macro or ?? 1
Need help modifying code 0

Top