Hi Connie,

It looks like you have a small error in your function. In the first
argument of the COUNTIF function, you have the beginning of the range
containing a static column AND row and the end of the range has a static
column but a dynamic row, the $ before either the column or row means that
it will not change as you auto-extend, it remains static. Try this:

=COUNTIF($L3:$L185,$L185)

For the IF function, it looks like you may NEED static columns, so try this:

=IF($Q185="","",$S185-$T185)

Let me know if this works for you

~Rob Walton


"Connie Martin" <ConnieMartin@discussions.microsoft.com> wrote in message
news:F2C64269-4843-41E3-B8EF-5AF53DB53365@microsoft.com...
> Does the auto extend list for formulas not work with this type of formula:
> =COUNTIF($L$3:$L185,$L185) ?? I have another formula in the same
> worksheet, which is: =IF(Q185="","",S185-T185) and the auto extended
> formula
> function works with it when new data in typed in the next empty row, but
> won't for the other formula. Any answers? Connie