I have an IF Statement
=IF(A1>100,"pass","fail")
"pass" = True (or 1)
However Autosum is not counting the True statement as 1?
I have an IF Statement
=IF(A1>100,"pass","fail")
"pass" = True (or 1)
However Autosum is not counting the True statement as 1?
Last edited by darkboost; 02-09-2009 at 06:57 PM.
Worked it out
=COUNTIF(A1:D1,"pass")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks