and query

  • Thread starter Thread starter digitallifeform
  • Start date Start date
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
 
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.
 
You could use the following formula:

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

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