How do I use ">$E$5" as the criteria using SUMIF and have it work.

L

Lisa

The criteria for this formula does not work. =SUMIF(B5:B14,">$E$5",C5:C14)
If I put ">5000" it works, but if I reference the cell E5 instead (which is
on the same sheet), it no longer works. I need to reference the cell as the
value will not always be 5000.
 
P

Peo Sjoblom

Use

">"&$E$5

instead as criteria, else it will look for the text representation of the
cell name and not its contents

Regards,

Peo Sjoblom
 

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

SUMIF with criteria "<>" & "=" 4
How to refer to a criterie in a cell using excel sum.if function 3
Use TODAY() function as the criteria in a SUMIF formula 1
Payment calculation 1
VLOOKUP or SUMIF for Multiple Criteria 2
Stripe out duplicate data 5
Have the SUMIF result (formula) on a separate sheet/tab 2
MedianIf multiple range and criteria 5

Top