Add values based on query

Closed

Sanjib - Jun 14, 2010 at 01:07 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2010 at 05:00 AM

Hello,

i have data in various sheets in excel which i want to add in summary sheet based on query. for exam. i have sheets named B1,B2,B3,B4,B5
& Summary Sheet. In Summary Sheet when I enter B1 TO b4 i must get the addition of Sheet B1+b2+b3+b4 and so on. i will appreciate ur help on this.

Based on the values in cells b77 b81
Excel macro to create new sheet based on value in cells - Guide
Fill adjacent cell with number from text answer ✓ - Excel Forum
We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
Auto serial number in excel based on another column ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 14, 2010 at 05:00 AM

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too

Similar discussions

help me to add particular cells

Return Seq Values Until Blank value then return different set of seq values

How do I change a base location on Instagram?

two values to find on the same cell

Condition formatting on changing cell color based on another cel

Similar discussions

Subscribe To Our Newsletter!