I have a spreadsheet and the only column that matters is D.

Down column D it appears as:
a
b
b
b
c
c
d
e
f
c
a

I need the result to just appear like
A - 2
B - 3
C - 3
D - 1
E - 1
F - 1

look at "totals" query - you need the count function

click the sigma icon in the query design pane

I figured it out. Just used a Simple Amount: SUM(IIf([Name]=[Name],1,0)