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 =A1B1
2 3 =A2B2
3 2 =A3B3
4 1 =A4B4

=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 =A1B1
2 3 =A2B2
3 2 =A3B3
4 1 =A4B4

=countif(C1:C4,TRUE)

hope this helps.


"Neffa" wrote:

struggling here

?B?TmVmZmE=?= wrote in
:

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:A5B1: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:

?B?TmVmZmE=?= wrote in
:

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:A5B1:B5)*1)

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

?B?TmVmZmE=?= wrote in
:

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.