Combo box

[IanT]

Hi

I have a form which has three combo boxs, which have 'Yes' 'No' 'N/A' as selection criteria, I need to be able to the count the number of 'Yes' selected in the boxs and the total number answered and place the total in text boxs. Can anyone point me in the right direction.

Ta

 

[Programmer]

= COUNTIF(C1:C65000,"yes") Just chaned the C to whatever column you are refering to.