Excel Forum

formula of summation in excel

Salim Gul

Member

Members

Forum Posts: 37

Member Since:
December 24, 2018

Offline

October 26, 2019 - 12:37 am

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

SunnyKow

Puchong, Malaysia

VIP

Members

Trusted Members

Forum Posts: 1432

Member Since:
June 25, 2016

Offline

October 26, 2019 - 2:01 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.myonlinetraininghu.....-explained

Hope this helps.

Sunny

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online:

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

yashal minahil

Oluwadamilola Ogun

Yannik H

dectator mang

Francis Drouillard

Orlando Inocente

Jovitha Clemence

Maloxat Axmatovna

Ricardo Freitas

Marko Meglic

Forum Stats:

Groups: 3

Forums: 24

Topics: 6201

Posts: 27185

Member Stats:

Guest Posters: 49

Members: 31861

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen