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
Pate values - Office Software Forum
#Value - Excel Forum
Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
VBA Macro to calculate values in cell(s) from multiple sheets - Excel Forum
Name Values - 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

Find values based on colum and sum in a table

fixing populating values into textboxes based on showing data in listbox

Conversion of values already present in cells

two values to find on the same cell

Similar discussions

Subscribe To Our Newsletter!