Forum

Notifications
Clear all

formula of summation in excel

2 Posts
2 Users
0 Reactions
167 Views
(@salim-gul)
Posts: 33
Trusted Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
Share: