Results 1 to 3 of 3

Conditional Sum: Simple but very frustrating question

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2009
    Location
    Helsinki
    MS-Off Ver
    Excel 2003
    Posts
    1

    Conditional Sum: Simple but very frustrating question

    Hello All,
    I have a quite simple need but I cannot find the right syntaxe

    start end A X Y
    10 30 15 46
    40 90 2 48
    60 80 3 50
    80 110 0 52
    70 130 26 54
    90 100 5 56
    20 70 0 58
    40 60 1 60
    60 90 0 62
    20 90 3 64
    50 70 2 66
    68
    70
    72
    74

    I have to calculate Y for each X value. Each Y should be the sum of the whole column A, with some condition. The condition is that the A value will be summed if the X value corresponding to the Y we calculate, is >= to the start and <= to the end.
    What is the exact function syntaxe I have to use in the Y column ?

    I would be so thankfull if somebody could help on that.

    Filipp
    Attached Files Attached Files
    Last edited by Filipp; 02-18-2009 at 03:12 PM.

Thread Information

Users Browsing this Thread

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

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