Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Unanswered: countif on column A * count in Column B

    Hi! I am attempting the following function:

    I have a row with two columns like this:

    Rating | Times climbed
    5.9 | 1
    5.10 | 5
    5.7 | 1
    5.10 | 2
    5.9 | 5

    The end result of what I want to do is to count the number of times I have climbed something of each rating. So I would have a cell totaling all the 5.9s that I have climbed (6 in this instance).

    I was attempting to use the countif function on the "rating" column, but I could not figure out how to multiply it by its corresponding "times climbed" column.

    Any suggestions would be great.

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    Rather than using COUNTIF, you need to use SUMIF.

    =SUMIF(A2:A6,"=5.9",B2:B6)

    So that sums the values in column B if the corresponding values in column A are equal to 5.9.
    I've just written a pretty extensive tutorial on SUMIF on my blog.

Posting Permissions

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