convert higlighted days inexcel calendar to value, then sum

T

Twishlist

I have an excel calendar on which I have highlighted particular dates. I
would like a formula that looks at the range and counts the cells that are
highlighted yellow, then multiplies that number by a x hours.
Is that easy to achieve?
 

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

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Drop-down calendar for sheet 0
COUNTIF using formatting 4
Conditional Formatting Less Than Today Week Days only 0
Conditional Formatting Date Range 2
Calculation of weighed average 6
Use TODAY() function as the criteria in a SUMIF formula 1
Month days over a time period 5

Top