Summary based on individual data cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2342281%22%20slang%3D%22en-US%22%3ESummary%20based%20on%20individual%20data%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2342281%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20would%20like%20to%20make%20a%20summary%20sheet%20based%20off%20of%20a%20single%20given%20cell%20across%20multiple%20tabs%2C%20how%20am%20I%20able%20to%20do%20this%20while%20also%20pulling%20the%20name%20from%20each%20tab%20as%20well%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2342281%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2342684%22%20slang%3D%22en-US%22%3ERe%3A%20Summary%20based%20on%20individual%20data%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2342684%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1050129%22%20target%3D%22_blank%22%3E%40bsmithconcrete%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20attaching%20a%20sheet%20that%20sums%20(in%20Cell%20A1%20of%20Sheet6)%20the%20contents%20of%20Cell%20A1%20in%20each%20of%20the%20five%20preceding%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20formula%20that%20accomplished%20that%3A%20%3CSTRONG%3E%3DSUM(Sheet1%3ASheet5!A1)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20not%20clear%2C%20however%2C%20whether%20that's%20what%20you're%20looking%20for.%20And%20frankly%2C%20although%20that%20shows%20that%20it's%20possible%20to%20do%20something%20like%20summing%20all%20the%20A1%20cells%2C%20I'm%20curious%20what%20your%20bigger%20picture%20is%2C%20what%20all%20those%20individual%20sheets%20are%20about%2C%20whether%20it's%20even%20necessary%20to%20have%20multiple%20sheets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20it%20be%20possible%20for%20you%20to%20post%20a%20copy%20of%20your%20actual%20workbook%3F%20If%20it%20contains%20proprietary%20business%20info%2C%20create%20a%20mockup%20using%20fictitious%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I would like to make a summary sheet based off of a single given cell across multiple tabs, how am I able to do this while also pulling the name from each tab as well?

1 Reply

@bsmithconcrete 

 

I'm attaching a sheet that sums (in Cell A1 of Sheet6) the contents of Cell A1 in each of the five preceding sheets.

 

Here's the formula that accomplished that: =SUM(Sheet1:Sheet5!A1)

 

It's not clear, however, whether that's what you're looking for. And frankly, although that shows that it's possible to do something like summing all the A1 cells, I'm curious what your bigger picture is, what all those individual sheets are about, whether it's even necessary to have multiple sheets.

 

Would it be possible for you to post a copy of your actual workbook? If it contains proprietary business info, create a mockup using fictitious data.