If Statement with True and Sums

[suzette0735]

Hello, I am having trouble with a formula. I have written this statement and it works: IF(T86=TRUE,'Estimate Sheet'!Q22-'Estimate Sheet'!P22,'Estimate Sheet'!Q22). However, I need to now sum Q22:29, P22:29 , and then Q22:29 instead of just referencing one cell for each part. Can you help me? I do not think I am rewriting it correctly as I keep getting an error. Thank you!

 

[Joe4]

Is this what you are looking for?

=IF(T86=TRUE,SUM('Estimate Sheet'!Q22:Q29)-SUM('Estimate Sheet'!P22:P29),SUM('Estimate Sheet'!Q22:Q29))

 

[suzette0735]

YESSSS! Thank you so very much for your quick help!!!

 

[Joe4]

You are welcome.
Glad I was able to help!