Ahmed Saad
Active Member
Members
Forum Posts: 4
Member Since:
May 11, 2020
May 11, 2020
Offline
Hi Mynda
i need to make a calculation on a range of data in one equation in one cell by writing start and end date of the data , attached example is a very simple one but i am working on a 4 years data file , so your help is highly appreciated
Purfleet
England
Member
Members
Trusted Members
Trusted Members
Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019
Offline
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
VIP
Members
Forum Posts: 346
Member Since:
April 21, 2015
April 21, 2015
Offline
Hi Ahmed,
I think the sumifs is the solution for you for this question.
Here your file with two calculations: one 'handmade' (dates) and one referring to the dates you provided.
Is this what you were looking for?
Frans
Answers Post
The following users say thank you to Frans Visser for this useful post:
PurfleetPurfleet
England
Member
Members
Trusted Members
Trusted Members
Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019
Offline
Purfleet
England
Member
Members
Trusted Members
Trusted Members
Forum Posts: 414
Member Since:
December 20, 2019
December 20, 2019
Offline
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Claudine Beunens, Charles Johnson, Riny van Eekelen, Alexandra Tataru
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30158
Member Stats:
Guest Posters: 49
Members: 33702
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —