formula

  • Thread starter Thread starter crabt23
  • Start date Start date
C

crabt23

The following code is part of an array formula I have
written: (F1:F25<100). However, I would like a code that
would find data not just <100 but also > 25??
 
=countif(F1:F25>25)-countif(F1:F25>=100)

=sumproduct((F1:F25>25)*(F1:F25<100))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Translate to code 5
exporting multiple ranges to a gif gile 2
Should I be content with the time code takes? 2
Insert formula and copy to a range of cells above 2
Excel Conditional formula for different scenarios 0
simplify SUMIF stmts 4
Cell ref is it possibile to calculate / change this in a formula 3
Efficiently moving data between worksheets and VBA array variables 1

Back
Top