Best Of

That's because you have an IF statement in there without it's various arguments. Get rid of the IF and you should see the result you're looking for. You can wrap it in an IFERROR statement if you want to remove errors like DIVIDE BY ZERO.

=IFERROR(([Column 9]32-[Column 9]28)/[Column 9]28,"")

Or if you want to use IF to check for things like 0 values like you have on your archive sheet, you need to finish the IF statement. Like

=IFERROR(IF(([Column 9]32-[Column 9]28)/[Column 9]28 =0, "", ([Column 9]32-[Column 9]28)/[Column 9]28) ,"")

Leading zeros will affect this because that changes it from numerical data to a text string. Now you have two different data types within the range, and that throws the COUNTIFS off every time.

Insert a helper column (can be hidden after setting up) and use this to convert every row into a text string.

=[ID Number]@row + ""

plus quote quote

Then reference this helper column in your COUNTIFS.

Try an @cell reference in your COUNTIFS.

=IF(COUNTIFS([Column Name]:[Column Name], @cell = [Column Name]@row)> 1, 1)

What's the logic? It looks to me like you want to output a date. If the date is less than or equal to the third of the month then output the date, otherwise output the date plus 30 days?

If so, it would look something like:

=IF(DAY([Date Column]@row)<= 3, [Date Column]@row, [Date Column]@row + 30)