Thread: Sum of check boxes that have been checked
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Sum of check boxes that have been checked
Assuming A1:A10 are the linked cells.

=COUNTIF(A1:A10,TRUE)

--
Biff
Microsoft Excel MVP


"confused??" wrote in message
...
I have a list of check boxes in a spread sheet that are all linked to the
corresponding cell and I would like to add up in a different cell how many
of
those check boxes have been checked.

Can anyone please help me?


Reply With QuoteReply With Quote