If then in excel
 

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?

If then in excel
 

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?

If then in excel
 

....."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?