+ Reply to Thread
Results 1 to 7 of 7

need help calcutating sum based on two criteria

Hybrid View

  1. #1
    Registered User
    Join Date
    12-07-2006
    Posts
    2

    need help calcutating sum based on two criteria

    i am doing a forgien exchange investment worksheet and i want a statment to caulate the sum base on two criteia.

    e.g find the sum base on "USD" and "Buy" and the answer should be 4000 (3000+1000) see below.

    the cells look like this

    column A = currency
    column B = transaction record (buy/sell)
    column C= amount involved

    A B C
    Currency transaction amount
    1 Yen BUY 100000
    2 GBP Sell 2000
    3 USD Buy 1000
    4 USD Buy 3000
    5 HKD Sell 5000
    6 USD Sell 600

    Thx in advance
    Last edited by Mish; 12-07-2006 at 03:14 PM.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Attached is your sample worksheet

    HTH
    Carim
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-07-2006
    Posts
    2
    thank you so much

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    No problem ...

    Thanks for the feedback

    Carim

  5. #5
    Registered User
    Join Date
    10-19-2005
    Posts
    48
    How timely. I had just the same question.

    Carim, can you explain what the double minus means? (you have ..--(A1:A6=F2)...)

    thx a lot,
    jm

  6. #6
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    It helps "converting" text into 0, 1 values and thus to allow for calculation ...

    HTH
    Carim

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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