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
This is what I tried.......
=IF((G2:G65534)="TRUE", count," ")

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.



OzGrid Business Applications

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