Results 1 to 10 of 10

multisheet lookup and sales calculation

Threaded View

  1. #1
    Registered User
    Join Date
    07-16-2013
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007
    Posts
    34

    Question multisheet lookup and sales calculation

    Hi Everyone
    I have a multisheet workbook in which there are three problems,,
    1) Sum Total sale of Jan for Henry with using sumif and also for other, I want to use only one formula which I can drag for other results

    2)When I put any mached number from six worksheets in A2 then display the Name in ROW B and ROW C display the Sales with simplest formula
    and

    3) when i put the name like "Henry" calculate all sales for Henry from all sheets
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sales Realization Calculation
    By Chandrashekhar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-25-2009, 03:20 AM
  2. Sales Commission Calculation
    By mobiay in forum Excel General
    Replies: 1
    Last Post: 03-19-2008, 04:10 PM
  3. [SOLVED] Sales Tax Calculation
    By LMB in forum Excel - New Users/Basics
    Replies: 15
    Last Post: 07-10-2006, 03:34 AM
  4. [SOLVED] calculation sales monthwise
    By Rao Ratan Singh in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-01-2006, 08:35 AM
  5. Sales V Commission updated calculation
    By Carauto in forum Excel General
    Replies: 5
    Last Post: 12-09-2005, 11:11 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1