+ Reply to Thread
Results 1 to 2 of 2

Adding Conditional Column values ?

  1. #1
    Registered User
    Join Date
    02-11-2007
    Posts
    5

    Adding Conditional Column values ?

    Hey
    I am new to excel, I need to add column A values. Some thing like this will give me complete total of column A =SUM(A1:An). How will I do a conditional test. I need to add only those column A values whose Column B values is AB
    A B
    9 DT
    1 DT
    1 DT
    1 AB
    1 DT
    1 DT
    1 AB
    7 DT
    1 DT
    1 AB
    1 DT
    . .
    n n


    Thanks
    Asgar

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Use this formula:

    =SUMIF(B2:B12,"AB",A2:A12)

    Make sure to change the ranges (B2:B12, A2:A12) to your own ranges as needed.

+ 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