Results 1 to 3 of 3

2 columns of values, summing values in column 1 if corresponding number in column 2..

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2008
    Location
    new york
    Posts
    14

    2 columns of values, summing values in column 1 if corresponding number in column 2..

    Hi,

    If I have 2 columns of numbers, and I want to sum the number in column 1 if the numbers in column 2 meet a certain criteria.

    So, say I have $ amounts in Column A. I want to sum the $ amounts where the corresponding numbers in column B are >0 and <30.

    So
    Column A Column B
    5 20
    10 50
    2 0
    4 5

    Thus, the formula should add 5+4 = 9 automatically

    Any help is very much appreciated! Thanks!
    Attached Files Attached Files

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