Notifications
Clear all
Topic starter
Dear
kindly guide me formula of summation
for example there are some values in a column (0.2, 0.5, 0.8, 0.3, 0.9, 0.1, 0.6, 0.4, 0.2, 1, 1.5, 1.7....
now i want to sum of all values from 0.1 to 0.49, 0.5 to 0.99 and 1 to 2, separately, what formula will be used
regards
salim
Posted : 26/10/2019 10:37 am
Hi Salim
You can try
=SUMIFS(A:A,A:A,">=0.1",A:A,"<=0.49")
=SUMIFS(A:A,A:A,">=0.5",A:A,"<=0.99")
=SUMIFS(A:A,A:A,">=1",A:A,"<=2")
and so on.
You can refer here for more details: https://www.myonlinetraininghub.com/excel-sumif-and-sumifs-formulas-explained
Hope this helps.
Sunny
Posted : 26/10/2019 12:01 pm