Hi All,
I have been trying to solve this problem now for a while and could do with some guidance.
My sheet contains two lists of users and two sets of values and I need my formula to be able to calculate one of the values (C2, D2) if there name appears in E2 and another if in F2.
On top of all of that, I need it to only search within a specific date range that is specified in A2 onwards.
This will generate a report that is split by month.
I hope I have explained myself sufficiently!
I have attached a copy of the basic sheet with some test data for you to maybe better understand.
Any help would be massively appreciated.
Bookmarks