Sum across entire sheet.
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Sum across entire sheet.
Hello Friends, I need to sum from base PPE Not To Consolidated Note. But ranges ar different but the structure or PPE Notes are same, also the heading of Consolidated PPE notes is Uniqal. What formula can I use to sum all PPE Notes into 1 Note?
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sum across entire sheet.
Could you provide some examples of the calculations needed? Since I cannot read Georgian, it's difficult for me to understand what you want.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Re: Sum across entire sheet.
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sum across entire sheet.
Why should Base!B67 be included in the sum in B4? The date in Base!A67 is different from the date in A4, as far as I can tell.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Re: Sum across entire sheet.
Dates in fact are the same and must be the same. 31/12/2018 and 01/01/2019. But I have a little error A67 must be 01/01/2019. So I would then replace this errors, but are then any formula if the dates and all other structure of notes would be the same and unequal?
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sum across entire sheet.
I'm sorry, but I don't understand how this would work.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Re: Sum across entire sheet.
Ok, I would explain in more detail lately with a simple workbook..