Super Easy Data Validation Question With Sums..

[figuare9]

For the last hour I've been googling this, and came up with nothing. So I figured I'd come and introduce myself on here.. haha..

I'll just make this short and sweet. Here's what I have.. I want to make an IF statement in data validation so IF the days used is more then the days available (Bottom left) I'll get an error. I can't seem to figure out how to do this in the data validation. Because the IF statement requires a pass, fail? I dunno.. A little help would be greatly appreciated!

 

[witsonjoyet]

Try this : =IFERROR(D11<=D13,FALSE) in data validation custom formula bar..

D11 - Days Used
D13 - Days Available

 

[figuare9]

wow.. IFERROR! lol. I had no idea.. So that worked perfectly for one cell. However, i'm looking to add a check for the sum. So lets say it's 1 day in Jan, and 4 in Feb, and then (by error of the person entering data) they hit 3 in March..

I selected all the cells Jan-Dec and entered that formula, but it still allows me to enter in 5 days per month without an error. How would I compensate for a sum check in that formula?

I tried this... =IFERROR(SUM(D5:O6)<=D14,FALSE) but it didn't work. The formula didn't give me errors though.. So thats good right? lol

Thanks for the help!