simple count or sum function??
 

does any one know how to simply, count the amount of times there is a
condition where two seperate colums have two different anwsers, i.e

from C10 to C20 "Yes" and in D10 to D20 "Selected", and all others can
be ignored, to count the amount tof times they match up in the same
row?????

please help im not very good @ excel


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

simple count or sum function??
 

use the countif function.

for example to count "Selected"

=COUNTIF(E9:E17,"Selected")




"Looker" wrote in message
...

does any one know how to simply, count the amount of times there is a
condition where two seperate colums have two different anwsers, i.e

from C10 to C20 "Yes" and in D10 to D20 "Selected", and all others can
be ignored, to count the amount tof times they match up in the same
row?????

please help im not very good @ excel


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/