• AVERAGE
  • AVERAGEIF
  • CELL REFERENCE
  • COUNT
  • COUNTA
  • COUNTIF
  • SUM
  • SUMIF
  • VLOOKUP
Get FREE step-by-step guidance on your question from our Excel Experts.
Quick Excel Help
  • AVERAGE
  • AVERAGEIF
  • CELL REFERENCE
  • COUNT
  • COUNTA
  • COUNTIF
  • SUM
  • SUMIF
  • VLOOKUP

Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

  • All solutions
  • PIVOT TABLE
  • General Questions
I want to only count unique instances of an array in a pivot table. For example client A has been invoiced twice for Product B and 3 times for Product C. I want to count the fact that Client A has used Product B and Product C ( ie a value of 1 for each) and not 2 for A and 3 for B
Solved by G. U. in 60 mins
How can I set up a pivot table to show "count of" totals by year across different columns (instead of just filtering year by year)
Solved by O. E. in 19 mins
I have a pivot table with data points per month and I am putting that into a spreadsheet (a budget). My problem is that I can't figure out to escalate each data point per column, i.e. ='Pivot Table 1'!E3 then the next column pulls from ='Pivot Table 1'!E4, the next ='Pivot Table 1'!E5...SO, how do I write a formula the right way?
Solved by E. C. in 11 mins
I added data to my table. Ive refreshed the pivot table but when I access "builder" within the table, I don't see my new column listed.
Solved by B. C. in 39 mins
I have a problem on creating a bubble chart from a pivot table.
Solved by V. Y. in 22 mins
1 2 … 5 6

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, see here: Cookie Policy
  • Home
  • About
  • Excel Tutorial
  • Excelchat
  • Contact
  • Excel Problems
  • Experts
© 2025 Got It, Inc. All rights reserved.
Got it! Your question will be answered by an Excelchat Expert. Hang tight for 30 secs while we redirect you.

Save time by asking instead! Most questions solved and answered in 10 minutes.

Post your problem and you’ll get expert help in seconds.
Your message must be at least 40 characters
Free trial ends in 00 days 12 hours