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


Purfleet
England
Member
Members

Trusted Members

Trusted Members

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

Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Leigh Thomas
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Trevor Pindling
Stevan Kanjo
Erin Sheldon
Nikita Bhatia
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28554
Member Stats:
Guest Posters: 49
Members: 32808
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —
