Results 1 to 2 of 2

Thread: excel help pls!

  1. #1
    Join Date
    Jun 2003
    Posts
    20

    Unanswered: excel help pls!

    How can I sum (in C Column) the values from the A Column which the character “AU” is in B Column and the same for the “BU” character?

    A B C
    1 AU sumAU=?
    5 AU sumBU=?
    45 BU
    2 AU
    9 BU

    Thanks,
    @lazarou

  2. #2
    Join Date
    Jul 2003
    Location
    Plainsboro, NJ
    Posts
    11
    You should use the =SumIf() Worksheet Function.

    It has the structure of =SumIf(EvaluateRange, CriteriaValue, SumRange)

    In your case:
    EvaluateRange is the B column
    CriteriaValue is "AU" (or "BU" or whatever).
    SumRange is the A column.

    So, =SumIf(B1:B5,"AU",A1:A5) would conditionally sum the values in cells A1:A5.

    Hope this helps,
    Mike

Posting Permissions

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