Results 1 to 5 of 5

Summing Difficulty - Linking Data based on Condition

Threaded View

  1. 08-24-2008, 03:17 PM #2
    Gearcutter
    Gearcutter is offline
    Forum Contributor
    Join Date
    08-21-2006
    Location
    Ossett, West Yorkshire
    MS-Off Ver
    2003
    Posts
    150

    Smile

    Hi
    If you allow a helper column in the Item Details sheet then you can use
    sumproduct function to calculate what you require

    see the attachment


    Regards Howard
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can Excel Draw Shapes or Angles based on Data?
    By chesspupil in forum Excel General
    Replies: 15
    Last Post: 04-30-2016, 03:31 PM
  2. Maximum & Minimum Dates based on Condition
    By figs in forum Excel General
    Replies: 3
    Last Post: 08-20-2008, 09:43 PM
  3. Linking Data from Excel in Word - Question
    By paulabrozek in forum Excel General
    Replies: 2
    Last Post: 03-27-2008, 01:48 PM
  4. Macro to filter based on identical column data as opposed to entire record
    By marielb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2007, 12:27 PM
  5. finding data, based on location of other data.
    By davittp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2007, 11:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1