# Thread: countif on column A * count in Column B

1. Registered User
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. Registered User
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
•