0

Summation of certain cells (Function in Sheets)

Jet Reports Historic Posts

July 15, 2014 14:19

None

Follow

Good afternoon you all,
I have got my vendor analysis running with help from Hughes (see attached document).
The last step is to get a summation of certain values.
I would like to summarise the totals per vendor per company (see Tab Summation).
How can I arrange that?
Thanks & Kind regards,
Auke (Netherlands)

• Vendor details per company (Sheets).xlsx

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts July 16, 2014 11:21 Official comment

  Hi Gerard,
  
  Everything is solved.
  Very smart solution, Much appreciated !
  Aganin, thank you very much !
  
  Thanks & kind regards,
  Auke

• 0
  
  Jet Reports Historic Posts July 15, 2014 15:16

  Hi Auke,
  
  Sorry for my previous post. I did not check your file correctly so I made a mistake.
  
  What you can do is create a NamedRange for the total values. For example give the InvoicedAmount the Name "InvAmountTotal"
  In your summary sheet, in the column with the Invoiced Amount you can use the Indirect function like this:
  =INDIRECT("'" & C12 & "'!InvAmountTotal")
  C12 holds the CompanyName created by the NL("Rows").
  
  Hope this helps?
  
  Best regards,
  Gerard

• 0
  
  Jet Reports Historic Posts July 16, 2014 14:36

  Great. You are welcome of course.
  Glad I could help!
  
  Regards,
  Gerard