Forum Discussion
Help with SUMIF for good karma
Sure, at least some columns need to cut down here. This large number of columns screams out loud that something is going wrong here. The best way to do that, if not too many rows will have data in every single column of those, is to make a column (like "Request Type") which will have a different value for each team (in A2:A255). If one team requests more types, add more rows.
I also advise you to use tables which will retain a proper formatting and make formulae more understandable.
You may direct message me if you need more help.
KhaledDardiri wrote A well-planned design is halfway to victory.
One might even say it's 3/4 of the way. Certainly without a well-planned design, the result will be challenging to maintain, even if it "works"
This file looks like when someone is still not sure how to begin or arrange the flow of data.
The file has all the markings of a process of tracking which was manually maintained on large ledger sheets, with the thought that one could just transfer that same format over to Excel. An understandable point of view, perhaps, but one that almost by definition fails to take advantage of Excel's remarkable abilities to manipulate data, slicing and dicing, extracting and arraying -- Excel's abilities to do "the heavy lifting". A manual process transferred directly to Excel still requires the user to find the box into which to put a check mark or date or quantity. Whereas listing the transactions which are consist of date, who, what, where, which, how much....is a sufficient database that Pivot Tables or some of the dynamic array functions can then process and summarize in those same "boxes".
