drums4monty
10-28-2013, 04:16 AM
Hi
I have a spreadsheet with 24 grids which total up a count from other grids. I now need to total up these 24 grids into 1 Grand Total. Each grid is the exactly the same with rows called Cat 1, Cat 2, Cat 3 through to Cat 13 in col I, the count goes into col J. The Grand total grid is exactly the same size etc. as the others and is located at M21:N33.
I wrote this formula but it only sums the first grid, is there any way to sum them all? The grids are spaced out down the spreadsheet with blank rows in between.
=sum(vlookup(m21,$i$5:$k$780,2,FALSE))
I have a spreadsheet with 24 grids which total up a count from other grids. I now need to total up these 24 grids into 1 Grand Total. Each grid is the exactly the same with rows called Cat 1, Cat 2, Cat 3 through to Cat 13 in col I, the count goes into col J. The Grand total grid is exactly the same size etc. as the others and is located at M21:N33.
I wrote this formula but it only sums the first grid, is there any way to sum them all? The grids are spaced out down the spreadsheet with blank rows in between.
=sum(vlookup(m21,$i$5:$k$780,2,FALSE))