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

Top