have Excel retrieve conditional operator ( < > = ) from a cell

  • Thread starter Thread starter davidbarbetta
  • Start date Start date
D

davidbarbetta

I'd like to enter "<" ">" "=" "<=" ">=" in a cell (e.g. cell E11), and
then have a formula which evaluates based on that entry. (I'm
analyzing a ton of data and I need one formula I can paste throughout
the worksheet.) The formula I'm working with is:

=SUMPRODUCT(--(INDIRECT(E$9)<E$12),--(Machine=$B21))

Is there any way to substitute the entry in cell E11 ("<" ">" "=" etc)
for the "<" in my formula? Something like

=SUMPRODUCT(--(INDIRECT(E$9) LOGICOPERATOR(E$11) E$12),--(Machine=
$B21))

where LOGICOPERATOR(E$11) would be interpreted as "<" ">=" "=" or
whatever was in cell E11? Thanks!
 
Have a look at the database functions (i.e. DCOUNT(), DCOUNTA(), DSUM())...
Sounds like using DCOUNTA() will work for you.
 

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

Modifying a complex date formual to count months 4
Formula Result is "V6", need Excel to use cell "V6", not the resul 3
strange conditional format behavior 5
Finding the weighted average of text that have been given values 1
conditional formatting based on relative cell value 2
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET 6
Macro to copy a Cell Content automatically IF G12 cell <>"" 6
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5

Back
Top