Areallusernamestaken
New Member
- Joined
- Apr 16, 2021
- Messages
- 44
- Office Version
- 365
- Platform
- Windows
- Web
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!
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!