Want to write the following:
if cell X in column A=P and cell Y in column B=Q, then increase count by
one.
How can I do this?

Not without using VBA.

An example would be needed i.e. it only one occurence of cells X & Y? And
where is the count?

" wrote:

Want to write the following:
if cell X in column A=P and cell Y in column B=Q, then increase count by
one.
How can I do this?

....."it" should have been "is there"!

"Toppers" wrote:

Not without using VBA.

An example would be needed i.e. it only one occurence of cells X & Y? And
where is the count?

" wrote:

Want to write the following:
if cell X in column A=P and cell Y in column B=Q, then increase count by
one.
How can I do this?