0

Sum specific cells in a column

Jet Reports Historic Posts

September 14, 2012 17:35

None

Follow

Hi! All JetReport Designers:

Please see attachment. I would like to use NL("Rows") to replicate the Group, Team and Sales columns and list the sales amount and quantity for each sales. But the problem is the Team and group total rows. Since the sales pserson are retrieved from database, they are varied. I've tried to use the Excel formula to only sum odd rows for amount and even rows for quantity. But since I use NL(ROWS) to dynamically generate rows, the quantity and amount rows are not always even or odd, especially if I have the third rows, like posted invoice count, added for each sales besides amount and quantity. How can I use NL("Rows") and sum the amount and quantity correctly?

• Example.xlsx

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts September 14, 2012 20:42 Official comment

  Hi,
  
  I think you could just use an Excel SUMIF function. In your case, I created a couple of example SUMIF functions in cells F11 and F12 that look like this:
  
  =SUMIF(E5:E10,"Amount",F5:F10) =SUMIF(E5:E10,"Qty",F5:F10)
  Does something like this work for you?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts September 17, 2012 21:06

  Thanks, Hughes. It works!
  
  Andy