[Solved] Count & Sum The Value
[Solved] Count & Sum The Value
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
Reason: Add green tick
OpenOffice 4.1.6 on Windows 10
Re: Count & Sum The Value
In E2 I'd suggest using
In F2 I'd suggest using
Then highlight E2 & F2, copy, then paste for the rest of the entries in column D
Code: Select all
=COUNTIF($A$2:$A$19;D2)
Code: Select all
=sum($e$2:$e2)
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.
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.
Re: Count & Sum The Value
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
Re: Count & Sum The Value
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Count & Sum The Value
Thank you. didn't know I can add another function under the column for the pivot table.
OpenOffice 4.1.6 on Windows 10
Re: [Solved]Count & Sum The Value
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
Number | Sum - Duration | Count - Duration
OpenOffice 4.1.6 on Windows 10
- MrProgrammer
- Moderator
- Posts: 4895
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: Count & Sum The Value
Drag Data to the right. You should read Using the DataPilot where you will learn much more about what you can do with this feature.raykt wrote:How do I move the Sum - Duration or Count - Duration to another column?
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).
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).
Re: Count & Sum The Value
Thank you.. It saves my day. Appreciate the headups
OpenOffice 4.1.6 on Windows 10