Generate complex totals statement

[BamaFan]

I want to automatically generate a totals statement at the bottom of my spreadsheet like the following:

116 PAID MEMBERS, 100 EMAIL ADDRESSES, TOTAL DUES COLLECTED = $590

where the three numerical values (in bold) are generated into the text in a line of merged cells.

How can I do that? Is it even possible? I don’t know if I need to add more detail here.

To add some detail: I know how to calculate each of the numerical values using the functions COUNTIF(), COUNTA(), & SUM(). I am doing that already. I just want to embed those calculated values into the text strings that applies to them. And because this spreadsheet must be imported to other software such as third party apps, I want it at the bottom. Just makes it easier.

[Lupp]

Counting by formulas is possible. You need to learn about COUNT(), COUNTA(), COUNTIF(), COUNTIFS() probably, and additional functions are useful in the context depending on the specifics of the sheets. For adding up a column use SUM(), SUMIFS() or … depending on the specifics again.
Merging cells is evil.
Don’t insist on drawing totals below the data. That’s paper think. Placing totals above the data mostly is much more practical.

[robleyd]

Use the concatenation operator & to join your text and formulae. Something along the lines of:

= COUNTIF(paid members stuff) & " PAID MEMBERS, "& COUNTIF(whatever)&" EMAIL ADDRESSES, TOTAL DUES COLLECTED = "&SUM(dues)

Or there is a function CONCATENATE.

If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. That will help other people with the same question.

In case you need clarification, edit your question (not an answer) or comment the relevant answer.