COUNTIF value columnA > columnB

[Neffa]

struggling here

 

[Yong Heng]

Hi,

u can get around this by using additional column to find out if column A >
column B and count the TRUE values.

A B C
1 4 =A1>B1
2 3 =A2>B2
3 2 =A3>B3
4 1 =A4>B4

=countif(C1:C4,TRUE)

hope this helps.

 

[Neffa]

Thanks for the rapid response - I was kinda hoping that I might avoid some
"hidden" columns but your work around appears to be the most elegant solution
available.

Thanks again.
Neffa

 

[pub]

struggling here

what are you trying to accomplish?

do you just want to count the total number of times values in column A is
greater then the value next to it in column b?

try this formula

=SUMPRODUCT((A1:A5>B1:B5)*1)

just asjust the range to fit. its a sumproduct, so dont use A:A or B:B.
hope that helps.

 

[Neffa]

Brilliant (unless the value is 0 then it gets a little confused...)

I am totalling a large number of meetings where I am tracking vote results
both by # of votes totally but also the # of meetings where the vote gets up
or otherwise.

Neffa

 

[pub]

Brilliant (unless the value is 0 then it gets a little confused...)

I am totalling a large number of meetings where I am tracking vote
results both by # of votes totally but also the # of meetings where
the vote gets up or otherwise.

Neffa

glad i could help.

confused by 0? funny im not having a problem with 0 or blanks. are you
getting an error? you could probably correct it with a simple if()
statement...possibly with an iserror() thrown in.