Hi Folks,
I have the following formula used to track specific assets:
=SUMIF({EventDate_req}, $DateNeeded$1, {Asset2_Range})
This adds up the count in each row in the Asset2_Range that matches the date needed.
We created individual one column ranges for each asset (Asset1, Asset2, Asset3) etc.
Problem is we are using too many cross sheet references and need to replace each of these 1 column wide ranges with one range that has all the columns and then use an index (like we would with vlookup to select which column we want to check.
So if I create one range Called ALL_Assets_Range that has side by side columns Asset1, Asset2, Asset3.
Question is:
How do I update the formula above to point to the first column or the second column of this now multi column range?
For example to look up Asset2 it would be something like
=SUMIF({EventDate_req}, $DateNeeded$1, {ALL_Assets_Range[2]})
How do I accomplish the goal of making the last parameter return all values from the specific column of the multi column range??
The sheet is getting very slow so would appreciate any help on this formula and ways to speed up.
Thanks!