| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Count of certain cells | Excel Worksheet Functions | |||
| Getting 2 different answers for simple count | Excel Worksheet Functions | |||
| a simple count question ... ? | New Users to Excel | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Simple count function | Excel Worksheet Functions | |||
Linear Mode
