Thread: How do I exclude E11 from: =FREQUENCY(E$4:E$24,$B$27:$B$32)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ome ome is offline
external usenet poster
  
Posts: 1
Default 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)
Reply With QuoteReply With Quote