counting a specific record and inserting a row in excel to get the count

[icemonster]

so i have a vba sql string that i export to excel and it works fine, grouping and everything. what i want to know is let's say there are 3 statuses, paid, pending and received, basically in my excel i want them grouped and counted without having to go through a report and just using vba to export it directly to excel. is there a function or setting that does this?

 

[namliam]

You could try using a Pivot table? Does that suite your needs?

Else you could resort to using the SumIfs and CountIfs functions?