COUNT Thresholds

CRISTOS
NewLounger
Posts: 24
Joined: 23 Nov 2018, 20:24

COUNT Thresholds

Post by CRISTOS »

Hello,
Is there a way to count thresholds of different ID? I have spreadsheet of more than 300K.
Thank you!
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 79561
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: COUNT Thresholds

Post by HansV »

I'd add a column to group the amounts, then create a pivot table.
See the attached demo workbook.

Thresholds.xlsx
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

CRISTOS
NewLounger
Posts: 24
Joined: 23 Nov 2018, 20:24

Re: COUNT Thresholds

Post by CRISTOS »

Thank you so much Hans!!