Skipping rows but not skipping reference cells

[Areallusernamestaken]

Hi,


I want to have the formula below in every other row, but I don’t want it to skip reference numbers.


So I want:

In AK2, I have: =IFS(COUNT(AND(AC2,AD2)),AF2,COUNT(AD1),AF1)

In AK4: =IFS(COUNT(AND(AC3,AD3)),AF3,COUNT(AD2),AF2)

In AK6:= IFS(COUNT(AND(AC4,AD4)),AF4,COUNT(AD3),AF3)

In AK8: =IFS(COUNT(AND(AC5,AD5)),AF5,COUNT(AD4),AF4)


Is there a way to do this?


When I drag, it’s skipping reference cells. So in AK8, for example, it’s changing the references to AC8 and AD8.


Thank you!

 

[jasonb75]

Do you have any merged cells?

Are there other numeric values in the hours columns?

As I mentioned previously, if there are differences between the format of your data and the example that you provided earlier then there could be any number of reasons for it not working. The formula was based specifically on the format of the example, 1 row per ID with valid times, duplicate rows for the same ID containing #N/A errors.

 

[Areallusernamestaken]

It's working now! Thank you so much!
It was an issue with my Y column.