N
Narnimar
I am monthly getting a list of Values for a Item group Heading. Every month I
receive the list with its grand total which is always not in the same cell
due to no of item in the list. If Jan list has 26 items, Feb will be 32
items. I want a formula to look up and return the Grand total based on the
Item group Heading. E.g. In sheet of January column a1 has Item group
Heading. b2 to b28 has values for the items a2 to a28. and b29 is the Grand
Total. But in the Feb sheet has 32 items so the grand total is in b34 but not
in b29. If I want to summerize the group Heading monthly Grand totals in a
new sheet. Which single formula can I use so that it catches from the
location wherever the Grand total are located in the cells?
(P. S. I cant spend time for naming the groups and summerizing due to amount
of data I got is large.)
receive the list with its grand total which is always not in the same cell
due to no of item in the list. If Jan list has 26 items, Feb will be 32
items. I want a formula to look up and return the Grand total based on the
Item group Heading. E.g. In sheet of January column a1 has Item group
Heading. b2 to b28 has values for the items a2 to a28. and b29 is the Grand
Total. But in the Feb sheet has 32 items so the grand total is in b34 but not
in b29. If I want to summerize the group Heading monthly Grand totals in a
new sheet. Which single formula can I use so that it catches from the
location wherever the Grand total are located in the cells?
(P. S. I cant spend time for naming the groups and summerizing due to amount
of data I got is large.)