Forum Discussion
help with SUMIFS and offset
Hi all, I have a couple of formulas I need help with. In the attached spreadsheet: In column A-J I have a data set for which I am trying to calculate some financial outcomes. I have created a f...
robwill100 check the attached and see if this is what you want / need.
I added the new higher range to W7 and also added W8 as the MAX in col Q and then I could make all the calculations use array formulas.
Lastly I got rid of the pid part of that equation since that whole range is already filtered based on the partner ID matching M1 so you don't need that as part of the countif again.
Thanks for getting back to me so promptly, that's worked a treat.