Nested formulas

Irina Iatco

Hi,

I have 3 formulas and I was wandering if I can combine them into 1:

=COUNTIF({Survey Date}, Label@row)

=COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8")

=Percentage@row / Count@row

Thanks much!

David Tutwiler

I think that should be doable. But let me confirm I understand what you're trying to do. I think you're looking for a formula to CountIF:

1) The survey Date is the same as the Label@Row

AND

2) The Survey Grade is >= 8

And then once you have your count use is as the denominator of Percentage@row and that Count.

If that is correct I think you would want your formula to look like the following:

=Percentage@row / COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8")

Irina Iatco

@David Tutwiler Thank you, David! You inspired me :) to create this formula and it worked: =COUNTIFS({Survey Date}, Label@row, {Survey Grade}, ">=8") / COUNTIF({Survey Date}, Label@row)

David Tutwiler

Awesome! Glad to hear.