Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel referencing a tab Sum/Count Functions
- Thread starter dprayner
- Start date
You should just be able to use the formula wizard and do a sum where the selection range is on tab 1.
[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]
AnotherHiggins
Technical User
The easiest way, IMHO:
[ul][li]On Sheet2, type [blue]=sum([/blue][/li]
[li]Click on Tab1 and select whatever range you want[/li]
[li]Press [Enter][/li][/ul]
Now just repeat the steps above, except replace SUM with COUNT.
[tt]_____
[blue]-John[/blue][/tt]
Help us help you. Please read FAQ181-2886 before posting.
[ul][li]On Sheet2, type [blue]=sum([/blue][/li]
[li]Click on Tab1 and select whatever range you want[/li]
[li]Press [Enter][/li][/ul]
Now just repeat the steps above, except replace SUM with COUNT.
[tt]_____
[blue]-John[/blue][/tt]
Help us help you. Please read FAQ181-2886 before posting.
- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question
- Locked
- Question