I need some help with this one. I have the following formulas in cells AE30 and AE31 on a worksheet named Class Numbers; I am currently creating a template so all values should equal zero until student data is entered.
=IF(IntermediateB34!$H$6:$H$30>0,COUNTIF(IntermediateB3!$H$6:$H$30,'New Students'!$R$2),0)
------> this should count all the cells that are greater than 0 and = the value in New Students R2 (which is also zero in the template)
It returns the value 0 now, which is correct and when there is data it counts it correctly
=IF(IntermediateB4!$H$6:$H$30>0,COUNTIF(IntermediateB4!$H$6:$H$30,'New Students'!$R$2),0)
Returns a #VALUE! error and I can't figure out why.
I have gone through and checked that the cell formatting is the same in both places, the worksheet references are correct, I have evaluated the formulas in the reference worksheet and they solve out to zero as they should at the moment. I have also used error checking on the sheets and been told that all formulas are correct.
Strangely enough, if I enter the second formula as an array it calculates correctly. I will use this as a work around but would like to figure out why the error is occurring.
Any help is greatly appreciated
Bookmarks