Forum Discussion
Solved
Using a sum within IF formula
I'm adding a count of donations from multiple sheets that will be matched up to 175 donations. I'm using IF to say: if the total # of donations from each sheet < 176, return the total donation count ...
=IF(Sheet1!I8+Sheet2!I8+Sheet3!I8<175,Sheet1!I8+Sheet2!I8+Sheet3!I8,175)
This works in my sheet.
=MIN(Sheet1!I8+Sheet2!I8+Sheet3!I8,175)
An alternative could be this formula.
=IF(Sheet1!I8+Sheet2!I8+Sheet3!I8<175,Sheet1!I8+Sheet2!I8+Sheet3!I8,175)
This works in my sheet.
=MIN(Sheet1!I8+Sheet2!I8+Sheet3!I8,175)
An alternative could be this formula.
OliverScheurich, thank you that worked! I guess I didn't need the extra ( ). And thanks for sharing =min, haven't tried that one before. Appreciate your help.