[Solved] Count & Sum The Value

Discuss the spreadsheet application
Post Reply
raykt
Posts: 12
Joined: Sun Nov 08, 2020 12:19 pm

[Solved] Count & Sum The Value

Post by raykt »

How may I achieve the number, count(its appearance), and sum of its value?
Attachments
Sum&Count.ods
(10.16 KiB) Downloaded 105 times
Last edited by robleyd on Thu Jun 17, 2021 7:06 am, edited 4 times in total.
Reason: Add green tick
OpenOffice 4.1.6 on Windows 10
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Count & Sum The Value

Post by RusselB »

In E2 I'd suggest using

Code: Select all

=COUNTIF($A$2:$A$19;D2)
In F2 I'd suggest using

Code: Select all

=sum($e$2:$e2)
Then highlight E2 & F2, copy, then paste for the rest of the entries in column D
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
raykt
Posts: 12
Joined: Sun Nov 08, 2020 12:19 pm

Re: Count & Sum The Value

Post by raykt »

The record only has A and B columns. I would like to have something like pivot table but the pivot can only have one function column. The attached right-hand side D/E/F columns is what would like to achieve.
OpenOffice 4.1.6 on Windows 10
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Count & Sum The Value

Post by FJCC »

Is the pivot table in the attached file close enough to what you want? I chose two functions for the summary of Duration by double clicking on the Duration button in the Data field and holding the CTRL key while clicking on the Sum and Count functions.
Attachments
SumAndCount.ods
(12.41 KiB) Downloaded 102 times
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
raykt
Posts: 12
Joined: Sun Nov 08, 2020 12:19 pm

Re: Count & Sum The Value

Post by raykt »

Thank you. didn't know I can add another function under the column for the pivot table.
OpenOffice 4.1.6 on Windows 10
raykt
Posts: 12
Joined: Sun Nov 08, 2020 12:19 pm

Re: [Solved]Count & Sum The Value

Post by raykt »

How do I move the Sum - Duration or Count - Duration to another column? I would like to sort by either Sum or Count result.

Number | Sum - Duration | Count - Duration
OpenOffice 4.1.6 on Windows 10
User avatar
MrProgrammer
Moderator
Posts: 4895
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Count & Sum The Value

Post by MrProgrammer »

raykt wrote:How do I move the Sum - Duration or Count - Duration to another column?
Drag Data to the right.
↑ Begin drag
↑ Begin drag
↑ Release there
↑ Release there
↑ This happens
↑ This happens
You should read Using the DataPilot where you will learn much more about what you can do with this feature.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
raykt
Posts: 12
Joined: Sun Nov 08, 2020 12:19 pm

Re: Count & Sum The Value

Post by raykt »

Thank you.. It saves my day. Appreciate the headups
OpenOffice 4.1.6 on Windows 10
Post Reply