Good afternoon,
I don't need to use a SUMIF based on a cell value, I need the cell to calculate the SUM of cells then apply an IF function to make it match another cell. In the provided picture I need F10 to SUM F3:F9 (which it is doing) but then I need an additional formula that if F10 is greater than G10 then it will change F10 to equal G10. If F10 is less than G10 then don't change it. Maybe there's an easier or different function to be used for this and I'm over complicating it.
Thanks for any help/suggestions you can provide.
I don't need to use a SUMIF based on a cell value, I need the cell to calculate the SUM of cells then apply an IF function to make it match another cell. In the provided picture I need F10 to SUM F3:F9 (which it is doing) but then I need an additional formula that if F10 is greater than G10 then it will change F10 to equal G10. If F10 is less than G10 then don't change it. Maybe there's an easier or different function to be used for this and I'm over complicating it.
Thanks for any help/suggestions you can provide.