Hi Everyone,
I'm wondering if i can get some help wiring a formula for this: Basically i'm looking to have each column value divided by its unit price, and then the entire row summed up. I'm looking to do this with VLookups or Index/Match as the list of names and list of products could be infinitely large. I'd also like to avoid adding each column separately, because again, there could be infinitely many columns. Here's an picture of a really basic setup:
Untitled.png
If anyone has any tips for me or a place to start i'd be super appreciative!
Thanks,
Bookmarks