Hi
Ive been racking my brain trying to solve an issue with an ever changing export.
I need a Sumif formula to search between two rows depending on the text in them
Excell question.PNG
Im looking to Sumif "payment method 1", but the number of rows with "payment method 1" can change from export to export.
And the starting row of "Declared payments" can change.
So ideally i want to Sum If between a range criteria set by the text: "Declared payments" & "Total Declared payments".
To complicate things more i cant just Sumif the whole sheet as i need to ignore some "payment method 1", where its not applicable.
I thought a Sumif and Vlookup, but i dont know how to make them work together?
Bookmarks