I am attempting to calculate something, and it is based on an ever-growing horizontal list.
The list of supply item goes vertically, then each time I order supplies, it is listed in 2 new columns.
What I can not figure out is how to count the number of items from each vendor. Currently, I select each cell, each time. =F20+J20+T20+X20+AH20+AN20+AP20+AT20+AX20+AZ20+BB20+BD20
A better way has to exist. I researched pivot tables, but it appears they need a set area, and as this table keeps growing each week, I couldn't figure out how to do it.
I would think I could then use this same formula to be used on the header to count order per month.
Thanks
File is attached
Bookmarks