LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 527
Default Using checkboxes, can I write formulas based on what is checked?

Hi Liz

If you mean a checkbox object then the answer is no. However, the font
Windings2 gives the following symbols; Capital O gives a Tick and capital P
gives an X, there are other symbols you could use.

you might be able to use a SUMIF function, say you symbols in D2:d10 and you
want to count how many crosses (x's) Type Countif(D2:D10,"O"). This gives the
count of how many P in the range. Note it is a "O" the font just displays a
fancy X.

If you wanted to add numbers in column C that have a O in column D use
SUMIF(=SUMIF(D2:D10,"O",C2:C10)


Hope that this helps
Peter

"Liz" wrote:

If I use checkboxes for different types of defects, can I then create a
formula to add up what is checked?

Thanks,
Liz

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
conditional formulas based on form answers (yes, no checkboxes) Sarah Excel Discussion (Misc queries) 2 May 30th 07 03:27 PM
Group Checkboxes to only allow on "checked" box T.Roy Excel Worksheet Functions 6 May 17th 07 05:00 PM
Print a selection based on checked checkboxes Stefan van der Hooft Excel Worksheet Functions 0 May 2nd 07 09:34 AM
Sum Only Checked Checkboxes Beamers Excel Discussion (Misc queries) 3 October 23rd 06 10:52 PM
My checkboxes will not stay checked. NUMBnut Excel Discussion (Misc queries) 0 January 9th 06 09:01 PM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"