Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to come up with a function to allow me to count through 2 columns
of data looking for 2 different vaules in the same row. For Example: column A has a range of depths and column B has a # of observations and I am looking for a value of 1 in A and 3 in B in the same row A B 1 2 1 3 2 3 5 2 1 3 Obviously I should get back 2 as a result but I can't seem to put this into a function. I have tried to use a countif or an if statement to try to solve it. Anyone have any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
countif | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |