Hello All,
The following formula results in the #VALUE! error message
=IF($G$5:$G$75,"A*",COUNTIF($I$5:$I$75,">0%"))
Column G contains 3 versions of A, A+ and A- along with other letters and blank cells.
Column I contains cells with %'s and blank cells.
The equation needs to add the number of rows in column I that contain A, A+ and A- in column G.
Thank you,
Patrick
Bookmarks