struggling here

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" wrote:

> struggling here

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

"Yong Heng" wrote:

> 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" wrote:
>
> > struggling here

=?Utf-8?B?TmVmZmE=?= <(E-Mail Removed)> wrote in
news:E6EDFCEA-3F17-4E5B-B3B8-(E-Mail Removed):

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

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" wrote:

> =?Utf-8?B?TmVmZmE=?= <(E-Mail Removed)> wrote in
> news:E6EDFCEA-3F17-4E5B-B3B8-(E-Mail Removed):
>
> > 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.
>

=?Utf-8?B?TmVmZmE=?= <(E-Mail Removed)> wrote in
news:98077DC8-9D9B-4D9C-8ED0-(E-Mail Removed):

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