COUNTIF value columnA > columnB

  • Thread starter Thread starter Neffa
  • Start date Start date
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.
 
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
 
struggling here
Click to expand...

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.
 
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
 
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
Click to expand...

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.
 
Back
Top