Validate a total of a row

C

Charles

I have this, simplified, spreadsheet:
Name A, Name B, Name C, etc in columns B1 to M1
In row 2 to row 11 are Work Functions. The staff have to enter a time
against each function but the total for each row can not exceed 15 minutes.
Can someone help with the formula?

Thanks
 
I

igorek

1. use conditional formating to give you a red flag when the total is not 15
min.
2. Or use VBA to achieve the goal
 

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

Copy addition formula of non-consecutive horizontal cells 2
Mail Merge Directory Conditional Page Break 0
Merging from an Excel file with graphics 1
return multiple values when within range (greater than and less than) 11
Help with lots of formulas 3
Arriving at totals 2
Running Total Question 2
Need a proper guru! My head hurts ;( 1

Top