Forum Discussion

dinbo123's avatar
dinbo123
Copper Contributor
Mar 15, 2022

Formula Involving Multiple Worksheets

I would like my formulas on a page called "Reports" to reference data from the same cell range on multiple other worksheets within the same workbook. The other worksheets are in order labeled Women, ...
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Mar 15, 2022

dinbo123

Copy the data form the different sheets to a single sheet. You can then use formulas like the ones you now have.

  • dinbo123's avatar
    dinbo123
    Copper Contributor
    Mar 15, 2022

    HansVogelaarI appreciate the suggestion, but I need to keep the data separate and add to it as time goes on. The formula allows the data to be interactive. It's pulling the data from a separate sheet right now. I want it to do that across multiple sheets to combine into one table.

     

    The information I'm providing in this post is for a much smaller, simpler version of what I eventually want to apply it to. The end product needs to remain separate for record purposes. The formula I'm looking to create would allow me to pull data from all sheets dependent on the criteria I enter.

     

    I have used it for the sum function in the example formula below. For some reason, the same range method is not working for the functions I'm using this time.

     

    =SUM(Women:Infant!C2)