Easter Sale 2025

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Counting the amount of (multiple) tickets by calc

Counting the amount of (multiple) tickets by calc 8 years 10 months ago #35280

  • rakeshy
  • rakeshy's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 97
  • Thank you received: 3
Since there is no sold ticket counter within RSfrom and I am using Multiple tickets pulldown, it became quite a challange to see the amount of tickets that were sold.

My only solution for this was creating a Excel calculation. I'm not the best with it, but this is my solution that works well. Perhaps it comes to use for somebody else.

1. Go to RSevent Subscriptions
2. Set Filter to: Complete (Left below) to show only paid tickets
3. Select your event ticket
4. Export Subscribers
5. Import Event1.csv in Excel
6. Add the formula below

Add in a field somewhere this calc:
rename TicketA with your ticket name, reuse this formula in another Excel field for a different ticket: TicketB, it is now only for max 5 tickets being sold at once, only for max 1000 tickets sold.

=COUNTIF(I1:I1000;"*1 x TicketA*")+(COUNTIF(I1:I1000;"*2 x TicketA*")*2)+(COUNTIF(I1:I1000;"*3 x TicketA*")*3)+(COUNTIF(I1:I1000;"*4 x TicketA*")*4)+(COUNTIF(I1:I1000;"*5 x TicketA*")*5)
Last Edit: 8 years 10 months ago by rakeshy.
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!