I'm trying to calculate summary from data it's working fine with SUMIFS but it will take me longs to edit each Range in a single Row. A example of summary including data and preconfig SUMIFS attached and everything is working fine but I have bunch of products to list and it will take long, I think there is a possibility to use VLOOKUP with SUMIFS.
Can't I just use to define name for F:S on items sold sheet and in summary sheet i can have results with company name & datawise?
Looking for a solution.
Bookmarks