How can I have a count value in the body of a pivotable but a sum in the total?
I need some help:
How can I have a count value in the body of a pivotable but a sum in the total?
When I change the summarized value of the total from a count to a sum, the whole column changes to a sum.
Attached is an example of what I get and what I need.
Any help will be greatly appreciated.
Luis
you protected your worksheet, so I can't show the result.
F2=IF(E2=MAXIFS($E$2:$E$500,$A$2:$A$500,A2),E2,"")
After that a pivot table on column F.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi oeldere,
I appreciate the formula but I wasn't able to replicate the solution. I didn't know the file was protected. Please use the new file I upload to see your solution in action.
You are correct, that does not work.
Try this working one instead.
F2 =IF(AND(E2=MAXIFS($E$2:$E$500,$A$2:$A$500,A2),COUNTIF($A$2:$A2,$A2)=1),E2,"")
See the attached file.
Dear oeldre, what a smooth and straightforward solution.
I appreciate your help. This was precisely what I was looking for.
Glad I could help.
Thanks for marking the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks