MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula for counting "true"returns


Posted by Paul Magruder on February 26, 2001 4:52 AM

Can you please tell me if there is a formula for counting the times "TRUE" is returned from a
checkbox?
This is what I tried.......
=IF((G2:G65534)="TRUE", count," ")

Thanks
Paul Magruder


Posted by David Hawley on February 26, 2001 5:14 AM

Hi Paul

I'm assuming you are talking about a "CheckBox"(s) from the "Forms" toolbar that is embeded in a Worsheet and is/are linked to the range G2:G65536.

=COUNTIF(G2:G65536,"TRUE")


Dave


OzGrid Business Applications

Posted by Aladin Akyurek on February 26, 2001 5:15 AM

Try

=COUNTIF(G2:G65534,TRUE)

Aladin