# Formula not working

✭✭✭

The formula I am using

=COUNTIFS([Award Amt. Fall]:[Award Amt. Fall], >= [T&F Amt. Fall]@row)

Data for it:

ID

First Name

Last Name

Balance Due

123

Mickey

Mouse

\$1,641.20

\$1,642.00

456

Minnie

Mouse

\$1,000.00

\$1,000.00

789

Daffy

Duck

\$789.00

\$789.00

012

Daisy

Duck

\$1,840.00

\$1,922.00

345

Spongebob

Squarepants

\$974.00

\$800.00

678

Batman

Robin

\$3,477.00

\$2,000.00

I am trying to get a COUNTIF function to show how many individuals' payments are greater than or equal to the balance due.

• Overachievers

The way the countif works is to search a range for a particular value. The formula you have above has various values depending on the row you are in.

I think what you want to do is have an additional column say [Greater than payment due] which would be

=IF([Payment Made]@row >= [Balance Due]@row, "Yes", "No")

Then you can have another formula to count how many "Yes" responses you have.

[Yes responses] = COUNTIF([Greater than Payment due]:[Greater than Payment due], "Yes")

Hope that helps

• ✭✭✭✭✭✭

Are you getting an error message or an unexpected result? Are you able to provide more details? Are you trying to get a count in a single cell of how many rows meet the criteria, or are you wanting this formula on every row?

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!