Ask Your Question

Generate complex totals statement

asked 2020-02-12 20:29:36 +0100

BamaFan gravatar image

updated 2020-02-13 00:00:50 +0100

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


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.

edit retag flag offensive close merge delete



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.

Lupp gravatar imageLupp ( 2020-02-12 21:26:58 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-02-13 01:05:55 +0100

robleyd gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-12 20:29:36 +0100

Seen: 29 times

Last updated: Feb 13