ExcelBanter - How do I exclude E11 from: =FREQUENCY(E$4:E$24,$B$27:$B$32)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I exclude E11 from: =FREQUENCY(E$4:E$24,$B$27:$B$32) (https://www.excelbanter.com/excel-discussion-misc-queries/127188-how-do-i-exclude-e11-%3Dfrequency-e%244-e%2424-%24b%2427-%24b%2432.html)

ome

How do I exclude E11 from: =FREQUENCY(E$4:E$24,$B$27:$B$32)

I AM TRYING TO MAKE THE FOLLOWING FORMULA EXCLUDE CERTAIN CELLS IN THE ARRAY.
SO FOR INSTANCE, HOW WOULD I EXCLUDE THE CELL E11 fromTHE FOLLOWING FORMULA:
=FREQUENCY(E$4:E$24,$B$27:$B$32)

T. Valko

How do I exclude E11 from: =FREQUENCY(E$4:E$24,$B$27:$B$32)

Try this:

=FREQUENCY((E4:E10,E12:E24),B27:B32)

Biff

"ome" wrote in message
...
I AM TRYING TO MAKE THE FOLLOWING FORMULA EXCLUDE CERTAIN CELLS IN THE
ARRAY.
SO FOR INSTANCE, HOW WOULD I EXCLUDE THE CELL E11 fromTHE FOLLOWING
FORMULA:
=FREQUENCY(E$4:E$24,$B$27:$B$32)

All times are GMT +1. The time now is 05:06 AM.