If then in excel

[nfak]

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?

 

[Guest]

Not without using VBA.

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

 

[Guest]

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

Not without using VBA.

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