Log In
Register
Home
Active Member
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
See Answer
Trusted Members
December 20, 2019
Offline
Nothing attached. Be sure to click the upload button after selecting a file.
Active Member
May 11, 2020
Offline
sorry for that
i uploaded it
VIP
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:
PurfleetTrusted Members
December 20, 2019
Offline
I was convinced i replied to this yesterday, must have forgot the submit.
Yes sumifs ifs the perfect formula
Trusted Members
December 20, 2019
Offline
Just panicked then as we had different totals until i noticed you used Column C in the table (Column E in Excel) and i used column C in Excel which is A in the table.
At least we got the same result!
Active Member
May 11, 2020
Offline
thanks a lot for your help 
Active Member
May 11, 2020
Offline
Purfleet said
Just panicked then as we had different totals until i noticed you used Column C in the table (Column E in Excel) and i used column C in Excel which is A in the table.At least we got the same result!
thanks
1 Guest(s)
