Sum across entire sheet.

vaxo
3StarLounger
Posts: 320
Joined: 23 Mar 2017, 19:51

Sum across entire sheet.

Post by vaxo »

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.

User avatar
HansV
Administrator
Posts: 73825
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sum across entire sheet.

Post by HansV »

Could you provide some examples of the calculations needed? Since I cannot read Georgian, it's difficult for me to understand what you want.
Regards,
Hans

vaxo
3StarLounger
Posts: 320
Joined: 23 Mar 2017, 19:51

Re: Sum across entire sheet.

Post by vaxo »

PPE Help.xlsx
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 73825
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sum across entire sheet.

Post by HansV »

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.
Regards,
Hans

vaxo
3StarLounger
Posts: 320
Joined: 23 Mar 2017, 19:51

Re: Sum across entire sheet.

Post by vaxo »

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?

User avatar
HansV
Administrator
Posts: 73825
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sum across entire sheet.

Post by HansV »

I'm sorry, but I don't understand how this would work.
Regards,
Hans

vaxo
3StarLounger
Posts: 320
Joined: 23 Mar 2017, 19:51

Re: Sum across entire sheet.

Post by vaxo »

Ok, I would explain in more detail lately with a simple workbook..