Using a sum within IF formula

Copper Contributor

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 from each sheet, otherwise return 175. Here's what I entered, that's not working (edited for brevity), cell I8 in each sheet counts the # of donations on that sheet:
It returns the full text of my formula in the cell. Am I missing ( ) or is the syntax off?

2 Replies
best response confirmed by VI_Migration (Silver Contributor)



This works in my sheet.



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.