Formula not working

mwalkerMC

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	Payment Made
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.

Gillian C

Hi @mwalkerMC

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

Paul Newcome

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?