and query

D

digitallifeform

Hi all

This is my sum:

=COUNTIF(B:B,1)+COUNTIF(P:p,">=0")

But at the moment it counts both values, i need it to count only if
both of those match. For example if Cell B1 = 1 and Cell P1 = >1 then
it will count.

I am sure this is probably quite simple, but i am still at the 'simple'
stage : )

Many thanks, and merry christmas.

Darren
 
P

Paul

digitallifeform said:
Hi all

This is my sum:

=COUNTIF(B:B,1)+COUNTIF(P:p,">=0")

But at the moment it counts both values, i need it to count only if
both of those match. For example if Cell B1 = 1 and Cell P1 = >1 then
it will count.

I am sure this is probably quite simple, but i am still at the 'simple'
stage : )

Many thanks, and merry christmas.

Darren
Click to expand...

You can use something along these lines:
=SUMPRODUCT((B1:B1000=1)*(P1:p1000>=0))
Note that you cannot have whole column references, but you can include up to
65535 rows.
 
M

Mark

You could use the following formula:

=AND(B1=1,P1>=1)

It will return the result TRUE if both conditions are met
 
Top