Results 1 to 7 of 7

need help calcutating sum based on two criteria

Threaded 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.

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