Count Number of times one cell greater than another

**HavokJak** · 12-23-2015, 03:34 PM

Hi,

This should be an easy question, but I can not seem to find an answer. I need a formula to count the number of times one cell is greater than (Or less than, Or equal to) another.

For example
AB
15 5
11 14
13 16
12 7
12 15

I need a formula for how many times A is greater than B (3 in this specific case).

Any help would be greatly appreciated, Thank You

**Tony Valko** · 12-23-2015, 03:38 PM

Like this...

=SUMPRODUCT(--(A1:A5>B1:B5))

**HavokJak** · 12-23-2015, 09:48 PM

PERFECT. This was actually for part of another formula for that uses SUMPRODUCT, so that is actually perfect.

**Tony Valko** · 12-24-2015, 06:00 AM

Good deal. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

Count Number of times one cell greater than another

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Count Number of times one cell greater than another

Re: Count Number of times one cell greater than another

Re: Count Number of times one cell greater than another

Re: Count Number of times one cell greater than another

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count if one number of a concatenated cell is greater than 0

[SOLVED] How to count the number of times column B is greater than column A

Count the number of times a value greater than x is in an array

Count number of times a specific number is displayed in a cell ran

Count number of times a specific number is displayed in a cell ran

Count number of times a specific number is displayed in a cell ran

[SOLVED] Count number of times a specific number is displayed in a cell ran

Count number of times a specific number is displayed in a cell ran

Bookmarks

Bookmarks

Posting Permissions