Forum Discussion
Higher-End Excel Formula Help
Hello. Working on a massive spreadsheet. Background needed to understand question: - You have (3) Columns, Column A, B and C - These (3) columns are on Sheet "1" - All three columns have the sa...
Andruw Peace be upon you, sir. I hope you are well. If you're interested in this formula, perhaps I can be of assistance? It is:
1. Using SUMPRODUCT and MATCH (Excel 2016 and later):
This approach utilizes the power of SUMPRODUCT and MATCH to find the first row meeting both criteria and return the corresponding value. Here's the formula:
Excel =SUMPRODUCT((A40:A80=A4)*(B40:B80=B4)*(ROW(C40:C80)-39),C40:C80)
2. Using SUMIFS and INDEX (Works in all Excel versions):
This approach leverages SUMIFS to filter based on both criteria and then uses INDEX to pick the value from the filtered range. Here's the formula:
Excel =INDEX(C40:C80,SUMIFS(ROW(C40:C80)-39,A40:A80,A4,B40:B80,B4))
I would be grateful if you could remember me in your prayers
I would be grateful if you could remember me in your prayers