
Ahmed Saad
Active Member
Members

Forum Posts: 4
Member Since:
May 11, 2020
May 11, 2020

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: 412
Member Since:
December 20, 2019
December 20, 2019


Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
VIP
Members

Forum Posts: 346
Member Since:
April 21, 2015
April 21, 2015

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:
Purfleet
Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 412
Member Since:
December 20, 2019
December 20, 2019


Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 412
Member Since:
December 20, 2019
December 20, 2019

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Brian Pham, Riny van Eekelen
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 205
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
stuart burge
Bruce Tang Nian
Scot C
Othman AL MUTAIRI
Misael Gutierrez Sr.
Attif Ihsan
Kieran Fee
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Forum Stats:
Groups: 3
Forums: 24
Topics: 6223
Posts: 27295
Member Stats:
Guest Posters: 49
Members: 31920
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
