syntax error in numbers

Question

Level 1

8 points

syntax error in numbers

Hi there,

I am having trouble calculating the percentage compliance of a range of values in numbers.

I want to calculate the percentage compliance of my pH and other values, for pH this is a little more complex as the compliant range is between 6.5 and 8.5.

Any help on this would be greatly appreciated.

I have inserted the formula I am attempting to use below for reference, thanks.

FREQUENCY(C7:C16,≥6.5,C7:C16,≤8.5)

MacBook Air 13″, macOS 10.15

Posted on Oct 12, 2020 1:53 AM

Reply

Answer 1

SGIII

Level 8

37,562 points

Oct 12, 2020 3:46 AM in response to ciaran148

Is something like this what you mean?

=COUNTIFS(Table 1::B,">="&C2,Table 1::B,"<="&D2)/COUNTA(Table 1::B)

Substitute ; for , in the formula if your regions uses , as decimal separator.

What this does is count the number of values falling within the range and divides by the number of values.

SG

Reply

Answer 2

ciaran148 Author

Level 1

8 points

Oct 12, 2020 4:09 AM in response to SGIII

Thanks for such a quick and prompt reply, your formula solved my my query thank you.

Reply