Hi all,
I've been trying to figure out what formula will allow me to calculate the product of row L and whichever column has a value between row E and K, but to no avail. I'm looking for a formula that can be copied into the below boxes, to save time writing new formulas for each row.
Excel.jpg
Any help would be much appreciated,
Thanks,
Aidan
Bookmarks