LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 6th 17, 02:46 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Sep 2017
Posts: 1
Default Finding what makes up a summed cell in Excel

If I have a number of spreadsheets I am summing together, I use the formula that will sum the same cell on a range of tabs. Some of those tabs may not have any data in the cell I am summing. From the sum formula, is there a way to find out which tabs do have data that make up the sum without having to manually go through each tab?

Thanks for any help you can provide!

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using cell color in conditional format makes Excel unstable Andrew[_24_] Excel Programming 2 November 15th 07 02:08 PM
Finding the location of what was summed [email protected] Excel Worksheet Functions 3 May 21st 07 08:15 PM
Recording Macro - Excel makes reference to a specific cell FamilyGuy902 Excel Programming 4 November 24th 06 07:05 PM
Making cell reference absolute makes cell format text Excel Worksheet Functions 2 September 22nd 06 04:47 PM
Summed Cell won't update as I add data into the cell range... mrmer Excel Worksheet Functions 2 February 2nd 06 01:38 AM

All times are GMT +1. The time now is 07:58 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017