Hello!

First of all, I wish everyone here at GT a nice and sunny summer

Now, a question:

I have in my databaze a column "Maximum capacity" (Column Type = INT and Form Names are stored from 1 to 10).

I would like to show the total number of beds - is there some kind of simple global to do that?

That means, I need to show the sum of all the numbers (beds) of all the ads as a total amount.

Many thanks in advance!

EDIT:

Sorry, a small correction - it should calculate only ads that are marked as "I offer accommodation" (Column Name = Rent_or_hire; Column Type = ENUM; Form Names = 1 or 2, 1 is the one who is correct).