# Sum cells in range with values greater than 2

1. ## Sum cells in range with values greater than 2

Good evening people,

With this vba code i count all cells with a value higher then 2.
I want to ask if someone here knows a formula for doing this.

Thank you in advance.

Hennie

``Please Login or Register  to view this content.``

2. ## Re: Sum cells in range with values greater than 2

In C9 you could use:

=SUMIF(C3:C7,">2",C3:C7)

Copy that to D9, E9 and F9.

3. ## Re: Sum cells in range with values greater than 2

You don't need to reference the same range that you are summing and searching criteria...

i.e. =SUMIF(C3:C7,">2") will do.

4. ## Re: Sum cells in range with values greater than 2

Hello Paul,

Thank you very much for this formula!

Hennie

5. ## Re: Sum cells in range with values greater than 2

Originally Posted by NBVC
You don't need to reference the same range that you are summing and searching criteria...

i.e. =SUMIF(C3:C7,">2") will do.

Hello NBVC,

That's even more efficient, thanks!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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