Hello ExcelForum members,
I want to formulate a function that describes the following:
The sum of all cells, 4 columns left of all cells with the value 10.
I searched the internet and I found the OFFSET function. But in this case I get stuck at =SUM(OFFSET(.....
I don't know how to define (4 cells to the left of every cell containing the value 10)
Can someone help me?
I look forward to any help!
Thanks in advance,
Dyoerdt
Bookmarks