count check box

[ganeshm]

Dear all,

i have attached an excel sheet to count check boxes.

One sample is done for the first row. what formula should i use to count whole check box

Regards,
ganeshm

 

[Xiq]

Hi ganeshm

Try something like this:

=COUNTIF($V$6:$X$9,TRUE)

 

[ganeshm]

hi xiq,

each check box has value on the top say 1st chk box has 25, 2nd has 15 and the 3rd has 5.

I would like to calculate for the remaining rows too.

 

[Xiq]

Something like this?

 

[AIM]

@ganeshm ,

u can also use the following SUMPRODUCT formula :

=SUMPRODUCT(($V$6:$X$9=TRUE)*($Y$6:$AA$9))

Regards!!!

 

[NARAYANK991]

Hi Ganesh ,

I really do not know why you need to assign the linked cell addresses in this fashion.

If you assign the linked cell for each checkbox as it own cell , and format the entire range as ;;; , the TRUE / FALSE text will not be displayed. Thereafter , all you need is a simple formula such as :

=SUMPRODUCT((E7:P7)*($E$6:$P$6))

in Q7. Copy this downwards.

Narayan

 

[ganeshm]

thank you.