hi... i have problems with this formula pertaining to the > sign
=COUNTIFS('[SHPS Marks Consolidated.xlsx]Sheet1'!$1:$1048576,"P6-2",'[SHPS Marks Consolidated.xlsx]Sheet1'!$PH:$PH,">78.9")
can help to rectify?
I need the data for all scores >78.9
Anyone help please?
Bookmarks