How to make Checkbox & Formulas to work like Autofilter?

**benishiryo** · 05-01-2012, 09:38 AM

hey guys, how can I use checkboxes & formulas for it to work like an Autofilter? For eg, if I uncheck something, it should act like an Autofilter that unchecks the same thing & the total count should then reduce. Attached a worksheet to illustrate.

**jeffreybrown** · 05-01-2012, 09:43 AM

In L4, paste in this formula and copy down

=IF(I4,G4,"")

**benishiryo** · 05-01-2012, 10:43 AM

hi jeffreybrown,

thks for the response. that'll only work for the checkbox that is unchecked. it does not affect other green highlighted cells. Like "Lawyer" should be 2 & "Sports" should be 4.

**JosephP** · 05-01-2012, 12:22 PM

I reckon this oughta do it.

**benishiryo** · 05-01-2012, 08:29 PM

hi JosephP

that seems awesome. my actual data has 7-8 categories & more than 40 checkboxes, but your formula should be able to fit in nicely. Thanks alot!

**jeffreybrown** · 05-01-2012, 08:57 PM

Just as a note, this is worth looking at as an Alternative to checkboxes.

**benishiryo** · 05-05-2012, 01:51 AM

hey jeffreybrown,

appreciate the link. well, it does get very troublesome when there's alot of checkboxes to maintain. but it's somethin the bosses want. thanks anyway man.