Curtis Long
asked on
Sumif based on cell color
I use an Excel spreadsheet to calculate time for payroll. I would like to be able to use a sumif statement to calculate holiday, vacation, and sick time based on cell color. How can I do that? I have attached a copy of the spreadsheet I use.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you colour cells using Conditional Formatting, you can the use the same Conditions for a SUMIF(S) formula.
If the data is in a Table format then you can autofilter by colour and use SubTotal to sum the visible rows.
All solutions provided will work.
ASKER
Thanks!!
Pleased to help