Hi,
I'm trying to do a formula and keep getting stuck on it and getting to my wits end.
There's actually two, a sumif and a countif (I think at least)
One is a countif - to count how many clients are included in that week based on whether that week is after their start date but doesn't have a value in 'end date' meaning they were a current client in that week (but doesn't change the info for that week once they do have a value when they leave, just not included from that week on) and have a certain funding type in the next column
The other is a sumif of the weekly amounts if that week they are an existing client and have a certain funding type in the next column.
I have attached a spreadsheet example to show, on 3 tabs
I would really appreciate any help at all as this is out of my depth, I can do formulas based on say 2 conditions, but where it's based on conditions of one cell containing text, and another between two other values and then counting or summing a third is just throwing me off completely!
Bookmarks