Countif Problem

[Mike]

Okay, I've read through tons of threads, but nothing seems to answer my
question, or maybe I'm just not getting it.

I want to do a countif type formula to count all the rows where the value in
column G is bigger than column F.

=countif(G:G,">"&F:F) obviously I have no idea how this is supposed to work.

Any help?

 

[Douglas J. Steele]

CountIf is an Excel function: this newsgroup is for questions about Access,
the database product that's part of Office Professional.

Assuming you are asking about Excel, you'd be best off reposting to a
newsgroup related to Excel.

 

[Arvin Meyer [MVP]]

Use Immediate If

Expr1: IIf([Column G] > [Column F], True, False)

In a query it might look like:

SELECT [Column G], [Column F], IIf([Column G]>[Column F],True,False) AS
Expr1
FROM tblMyData;