Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS Excel, count on Pivot Table.

Posted on 2013-01-18
2
Medium Priority
?
310 Views
Last Modified: 2013-01-20
I have an excel file (attached file).

The count column (K) I typed by hand.

Is there any way to count it automatically?


Thank you!
leadtime-file--1.xlsx
0
Comment
Question by:JameMeck
2 Comments
 
LVL 7

Accepted Solution

by:
leptonka earned 2000 total points
ID: 38796234
Hi,

Just a quick-and-dirty - insert this formula in cell K6 and copy down:
=IF(B6="",K5+1,1)

Cheers,
Kris
0
 

Author Closing Comment

by:JameMeck
ID: 38799646
Ha,

Thank you!

So simple.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Currently, there is an issue with being able to copy values from an external application to a dropdown list in Project Web Access (PWA).  The standard copy and paste methods don't seem to work properly. Here is a way to accomplish this task to s…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question