youcanreachtrevor
New Member
- Joined
- May 17, 2018
- Messages
- 5
I have a single formula in an excel cell as follows.
=IF(LEFT($D9,4)="4040",SUM($U$5*U9,$CN$5*CN9,$DU$5*DU9,$FG$5*FG9,$GP$5*GP9), IF(LEFT($D9,2)="40",SUM($U$4*U9,$CN$4*CN9,$DU$4*DU9,$FG$4*FG9,$GP$4*GP9),IF(LEFT($D9,2)="45",SUM($U$6*U9,$CN$6*CN9,$DU$6*DU9,$FG$6*FG9,$GP$6*GP9),SUM($U$7*U9,$CN$7*CN9,$DU$7*DU9,$FG$7*FG9,$GP$7*GP9))))
I have about 2000 rows of data that requires this formula. Manually I would just fill this down. I am looking for a faster way to populate my final array product without having to go into the sheet and fill this down.
I want to add this as a column in my array without pointing to the sheet 2000 times.
Obviously I need it to fill as you would expect in Excel where the cells are properly referenced as the rows change.
Thank you
=IF(LEFT($D9,4)="4040",SUM($U$5*U9,$CN$5*CN9,$DU$5*DU9,$FG$5*FG9,$GP$5*GP9), IF(LEFT($D9,2)="40",SUM($U$4*U9,$CN$4*CN9,$DU$4*DU9,$FG$4*FG9,$GP$4*GP9),IF(LEFT($D9,2)="45",SUM($U$6*U9,$CN$6*CN9,$DU$6*DU9,$FG$6*FG9,$GP$6*GP9),SUM($U$7*U9,$CN$7*CN9,$DU$7*DU9,$FG$7*FG9,$GP$7*GP9))))
I have about 2000 rows of data that requires this formula. Manually I would just fill this down. I am looking for a faster way to populate my final array product without having to go into the sheet and fill this down.
I want to add this as a column in my array without pointing to the sheet 2000 times.
Obviously I need it to fill as you would expect in Excel where the cells are properly referenced as the rows change.
Thank you