How do I use ">$E$5" as the criteria using SUMIF and have it work.
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. |
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 "Lisa" wrote: 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. |
=SUMIF(B5:B14,""&$E$5,C5:C14)
HTH "Lisa" wrote in message ... 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. |
Hi Lisa
use =SUMIF(B5:B14,""&$E$5,C5:C14) Cheers JulieD "Lisa" wrote in message ... 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. |
Thanks everyone for your help!
Lisa |
All times are GMT +1. The time now is 09:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com