Multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i take data from the same ranges in multiple worksheets with multiple
criteria and use it in a sumery
 
I need to ty and get more specific please excuse me I know enough excel to
get into trouble

I need a formula to do the following

I have a summery page with that comapares our products to a competitors
I have our products listed on the a colum cells 2:20 and the competitors
along the a row cells 2:20

I have multiple data worksheets that are identical except for specific labels
e.g. sheet 2:4 have the same Heading and footing and the data that changes
fits in the same cells in all worksheets except summery sheet.

how can I compare our product to competitors by counting the number of times
that "AS123" (Our Product)is in the same worksheet that "ZX987"(Competitors)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif using Arrays 2
Best solution to merge multiple Outlook contacts easily 2
CREATING FORMULA IN ONE WORKSHEET BASED ON MULTIPLE CRITERIA IN AN 2
Drop down lists on multiple worksheets 2
Multiple sheet querries 4
DCOUNTA with multiple criteria 3
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
same range names in different worksheets 4

Back
Top