Calculations Using Data in List

[jrarmstrong]

Hi,

I have two columns of several hundred lines which contain lists of figures. Is it possible to firstly determine how many figures in the 2 columns (C and D) are less than or equal to 1.4 and then calculate the % of those figures that are in the first column rather than the second.

I have been scratching my head on this so any help would be appreciated.

Thanks,

James

 

[T. Valko]

Hi,

I have two columns of several hundred lines which contain lists of figures. Is it possible to firstly determine how many figures in the 2 columns (C and D) are less than or equal to 1.4 and then calculate the % of those figures that are in the first column rather than the second.

I have been scratching my head on this so any help would be appreciated.

Thanks,

James

Try these...

=COUNTIF(C2:D20,"<=1.4")

=COUNTIF(C2:C20,"<=1.4")/COUNTIF(C2:D20,"<=1.4")

Format as Percentage

 

[jrarmstrong]

Perfect. Thanks for your help

 

[T. Valko]

Perfect. Thanks for your help

You're welcome. Thanks for the feedback!