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
ID	123	First Name	Mickey	Last Name	Mouse	Balance Due	$1,641.20	Payment Made	$1,642.00
ID	456	First Name	Minnie	Last Name	Mouse	Balance Due	$1,000.00	Payment Made	$1,000.00
ID	789	First Name	Daffy	Last Name	Duck	Balance Due	$789.00	Payment Made	$789.00
ID	012	First Name	Daisy	Last Name	Duck	Balance Due	$1,840.00	Payment Made	$1,922.00
ID	345	First Name	Spongebob	Last Name	Squarepants	Balance Due	$974.00	Payment Made	$800.00
ID	678	First Name	Batman	Last Name	Robin	Balance Due	$3,477.00	Payment Made	$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?