Hello, Ive used countif and sumif statments alot but not utilizng multiple sheets usually the data and formula are all on the same sheet but i Have a worbook that has a years worth of data on it and each month has its own tab. I am creating a summary page at the front and I know i can just manually go through and look for the specific data on each sheet and do a regular addition formula but that could take along time. What I have is Markets as column A and then for instance two columns for member non-member. I want the summary sheet to tally the markets for these different items. For instance if my market is Downtown I want ot know over the course of the year how many items there were sold downtown and if they were sold to members or non members.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sumif statement for multipe worksheet
- Thread starter filmore34
- Start date
Similar threads
- Question
- Question
