I have a SumIf Formula that works good, but I need to add INDIRECT also to keep my cell references from changing when cells get deleted.
I currently have: =SUMIF(R28:R65536, ">=1", N28:N65536) This works good.
When I try and add in the INDIRECT I cant get it to accept it. How can I get this to work?
=SUMIF(INDIRECT("R28:R65536", &">=1", & "N28:N65536"))
Thanks.
I currently have: =SUMIF(R28:R65536, ">=1", N28:N65536) This works good.
When I try and add in the INDIRECT I cant get it to accept it. How can I get this to work?
=SUMIF(INDIRECT("R28:R65536", &">=1", & "N28:N65536"))
Thanks.