Forum Discussion
Limit sum to 100
Can anyone please help? Working in a column 1 where applying SUMIFS formula from another sheet having 51 different values. Among those 51 values I just need to see in Column1 upto sum 100 values....
You can simply use:
=MIN(100,SUM(A1:A50)
In case the sum exceeds 100, it will display only 100.
You can simply use:
=MIN(100,SUM(A1:A50)
In case the sum exceeds 100, it will display only 100.
- Thanks @Angosto.
