I know how to do sumif formulas but I can't wrap my mind around how to make it work for this or if it is even the right formual to us.
I have the following cells:
B22 - Original Contract Amount
L27 - Change Order Total
B26 - Revised Contract Amount
We will always have an amount in B22, but the other two are as needed. I only want B26 (Revised Contract Amount) to have total if both B22 and L27 have total. Is there a formula that can do this?
Bookmarks