How to validate a formulae

[jim-jams3]

I have a database on one sheet and a 2 count if formulae recording information on the next to be exact one formulae counts the number of monthly values and the other count yearly values. I want the sum of these formulaes to be equal or less than 25. and to show an error if the sum of these is mor than 25.

thanks jim

 

[jasonb75]

Mike, jim has sent me a copy of the workbook, and I'm having the same problems.

The data is imported from access so could this be the cause of the problem?

 

[mikerickson]

Unless I see the workbook, I'd just be guessing, but I'd check for extra spaces etc in the data and the sheet references.

Is the import embedding an object into the worksheet or is it writing values into cells?

 

[jasonb75]

Writing cell values, think I've solved it.

There was an original total with the formula =SUM(D9:D10), the 2 cells with the original countif formulae, I've simply changed that to =IF(SUM(D9:D10)>25,"ERROR",SUM(D9:D10)) And thrown in a conditional format to show red cell shading if the cell reads ERROR, it works ok when I insert some extra lines manually to break the 25 limit, so in theory it should work with if the database import exceeds it as well.

Think maybe we were just overcomplicating it.

 

[jim-jams3]

thank you thats fine