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?

=sumproduct((a2:a22=1)*(b2:b22=3))

--
Don Guillett
SalesAid Software

"paul/bones" wrote in message
...
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?

Is there any way I could set up the argument so it will count up too.
For example increase the value in A from 1 to 2 without havin to change it
by hand when it is dragged into new rows.

"Don Guillett" wrote:

=sumproduct((a2:a22=1)*(b2:b22=3))

--
Don Guillett
SalesAid Software

"paul/bones" wrote in message
...
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?

row()

--
Don Guillett
SalesAid Software

"paul/bones" wrote in message
...
Is there any way I could set up the argument so it will count up too.
For example increase the value in A from 1 to 2 without havin to change it
by hand when it is dragged into new rows.

"Don Guillett" wrote:

=sumproduct((a2:a22=1)*(b2:b22=3))

--
Don Guillett
SalesAid Software

"paul/bones" wrote in message
...
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?