COUNTA

Math & Aggregationbeginner

COUNTA counts cells that aren't empty — including text, numbers, dates, errors, and logical values. Unlike COUNT (which only counts numbers), COUNTA catches everything. Essential for data validation and figuring out how complete a column is.

Syntax

Excel:=COUNTA(value1, [value2], ...)
Google Sheets: Same syntax

Parameters

value1The first cell or range to evaluate.
value2?Additional cells or ranges.

? = optional parameter

Worked Example

How many invoices have a payment_date recorded (i.e., it's not blank)?

Row numbersAGH
Header rowinvoice_idstatuspayment_date
2INV-1001Paid2025-02-01
3INV-1002Paid2025-01-25
4INV-1006Pending
5INV-1008Overdue
6INV-1003Paid2025-02-10
7INV-1009Paid2025-03-22

Formula

=COUNTA(C2:C7)

Result

4

COUNTA checks C2 through C7 and counts the cells that are not blank. In this sample, C2, C3, C6, and C7 contain payment dates, while C4 and C5 are blank.

Practice Exercises

2 exercises - work through each one using the data table below

Exercise 1 of 2beginner
#COUNTA-001

Question

How many invoices in the dataset have a payment date recorded? (i.e., how many non-blank entries are in the payment_date column?)

Dataset

Vendor Spend Tracker (150 rows total)

Download CSV
Row numbersABCDE
Header row
2INV-1001Cloudline Software2025-01-15Paid2025-02-01
3INV-1002Apex Office Supply2025-01-18Paid2025-01-25
4INV-1003Summit Consulting Group2025-01-22Paid2025-02-10
5INV-1004Meridian Travel Co.2025-02-03Paid2025-02-15
6INV-1005Forge & Frame Creative2025-02-08Paid2025-02-20
7INV-1006NovaTech Solutions2025-02-14Pending--
8INV-1007Atlas Hardware Co.2025-02-19Paid2025-03-01
9INV-1008Clearview Data Systems2025-03-05Overdue--
10INV-1009Redstone Marketing2025-03-10Paid2025-03-22
11INV-1010Keystone Legal Advisors2025-03-15Paid2025-03-28
12INV-1011Cloudline Software2025-01-04Paid2025-01-18
13INV-1012Basecamp Events2025-01-09Paid2025-02-01
14INV-1013Apex Office Supply2025-01-10Paid2025-01-19
15INV-1014BrightPath Analytics2025-01-16Paid2025-02-01
16INV-1015Meridian Travel Co.2025-01-17Paid2025-01-29
17INV-1016Clearview Data Systems2025-01-21Paid2025-01-29
18INV-1017Apex Office Supply2025-02-09Paid2025-02-18
19INV-1018Summit Consulting Group2025-02-18Paid2025-02-28
20INV-1019Cloudline Software2025-02-19Paid2025-03-04
21INV-1020Atlas Hardware Co.2025-02-22Paid2025-03-19
22INV-1021Meridian Travel Co.2025-02-25Paid2025-03-17
23INV-1022Atlas Hardware Co.2025-03-02Pending--
24INV-1023Atlas Hardware Co.2025-03-04Paid2025-03-11
25INV-1024Apex Office Supply2025-03-10Paid2025-03-19
26INV-1025Redstone Marketing2025-03-12Paid2025-03-22
27INV-1026Clearview Data Systems2025-03-13Paid2025-03-31
28INV-1027Horizon IT Services2025-03-14Paid2025-03-30
29INV-1028Basecamp Events2025-03-14Paid2025-04-06
30INV-1029Redstone Marketing2025-03-15Paid2025-04-03
31INV-1030BrightPath Analytics2025-03-17Paid2025-04-10
32INV-1031Basecamp Events2025-03-19Paid2025-03-28
33INV-1032Cloudline Software2025-03-20Paid2025-03-31
34INV-1033Clearview Data Systems2025-04-01Pending--
35INV-1034Meridian Travel Co.2025-04-01Paid2025-04-23
36INV-1035Cloudline Software2025-04-03Paid2025-04-27
37INV-1036Horizon IT Services2025-04-05Paid2025-04-24
38INV-1037BrightPath Analytics2025-04-07Paid2025-04-15
39INV-1038Cloudline Software2025-04-10Paid2025-04-20
40INV-1039Horizon IT Services2025-04-11Paid2025-04-30
41INV-1040Apex Office Supply2025-04-15Paid2025-04-26
42INV-1041Summit Consulting Group2025-04-15Overdue--
43INV-1042Clearview Data Systems2025-04-16Paid2025-05-10
44INV-1043Forge & Frame Creative2025-04-17Paid2025-05-07
45INV-1044NovaTech Solutions2025-04-20Paid2025-05-05
46INV-1045Meridian Travel Co.2025-04-22Paid2025-05-10
47INV-1046Cloudline Software2025-04-23Paid2025-05-04
48INV-1047Apex Office Supply2025-04-24Paid2025-04-29
49INV-1048Apex Office Supply2025-05-01Paid2025-05-10
50INV-1049Pinecrest Staffing2025-05-03Paid2025-05-17
51INV-1050Clearview Data Systems2025-05-06Paid2025-05-30
52INV-1051BrightPath Analytics2025-05-15Overdue--
53INV-1052Keystone Legal Advisors2025-05-17Paid2025-05-31
54INV-1053Cloudline Software2025-05-18Paid2025-05-30
55INV-1054NovaTech Solutions2025-05-18Paid2025-05-30
56INV-1055Basecamp Events2025-05-21Paid2025-06-03
57INV-1056Cloudline Software2025-05-24Paid2025-06-05
58INV-1057NovaTech Solutions2025-06-01Paid2025-06-18
59INV-1058Clearview Data Systems2025-06-06Paid2025-06-27
60INV-1059Basecamp Events2025-06-07Paid2025-06-23
61INV-1060Horizon IT Services2025-06-10Paid2025-06-24
62INV-1061Atlas Hardware Co.2025-06-10Paid2025-06-17
63INV-1062Forge & Frame Creative2025-06-12Paid2025-06-22
64INV-1063Meridian Travel Co.2025-06-13Overdue--
65INV-1064Meridian Travel Co.2025-06-13Pending--
66INV-1065Cloudline Software2025-06-15Paid2025-07-01
67INV-1066Redstone Marketing2025-06-16Paid2025-07-07
68INV-1067Horizon IT Services2025-06-17Paid2025-06-26
69INV-1068Cloudline Software2025-06-23Paid2025-07-17
70INV-1069NovaTech Solutions2025-06-25Paid2025-07-06
71INV-1070Apex Office Supply2025-07-01Paid2025-07-11
72INV-1071Redstone Marketing2025-07-06Paid2025-07-22
73INV-1072NovaTech Solutions2025-07-07Overdue--
74INV-1073Summit Consulting Group2025-07-08Paid2025-07-22
75INV-1074Atlas Hardware Co.2025-07-08Paid2025-07-20
76INV-1075BrightPath Analytics2025-07-08Paid2025-07-31
77INV-1076Clearview Data Systems2025-07-09Paid2025-07-22
78INV-1077Meridian Travel Co.2025-07-11Paid2025-07-21
79INV-1078Pinecrest Staffing2025-07-11Paid2025-07-19
80INV-1079Meridian Travel Co.2025-07-13Paid2025-07-20
81INV-1080Greenfield Facilities2025-07-15Paid2025-07-24
82INV-1081Keystone Legal Advisors2025-07-16Paid2025-08-05
83INV-1082Apex Office Supply2025-07-17Paid2025-07-28
84INV-1083Cloudline Software2025-07-18Paid2025-07-30
85INV-1084Meridian Travel Co.2025-07-19Paid2025-07-26
86INV-1085Horizon IT Services2025-07-21Paid2025-08-06
87INV-1086Cloudline Software2025-07-23Paid2025-08-09
88INV-1087Apex Office Supply2025-08-04Paid2025-08-17
89INV-1088Pinecrest Staffing2025-08-04Paid2025-08-16
90INV-1089NovaTech Solutions2025-08-05Paid2025-08-20
91INV-1090Meridian Travel Co.2025-08-05Paid2025-08-21
92INV-1091Redstone Marketing2025-08-05Paid2025-08-24
93INV-1092Cloudline Software2025-08-07Paid2025-08-27
94INV-1093Cloudline Software2025-08-08Paid2025-08-23
95INV-1094BrightPath Analytics2025-08-09Paid2025-08-23
96INV-1095Redstone Marketing2025-08-12Paid2025-08-31
97INV-1096BrightPath Analytics2025-08-13Paid2025-08-26
98INV-1097Redstone Marketing2025-08-13Paid2025-09-06
99INV-1098Cloudline Software2025-08-15Paid2025-08-29
100INV-1099Meridian Travel Co.2025-08-15Paid2025-09-08
101INV-1100Meridian Travel Co.2025-08-16Pending--
102INV-1101Forge & Frame Creative2025-08-17Paid2025-08-27
103INV-1102Atlas Hardware Co.2025-08-17Paid2025-08-28
104INV-1103NovaTech Solutions2025-08-17Paid2025-08-27
105INV-1104Meridian Travel Co.2025-08-18Paid2025-09-12
106INV-1105NovaTech Solutions2025-08-22Paid2025-08-31
107INV-1106Pinecrest Staffing2025-08-24Overdue--
108INV-1107Basecamp Events2025-08-24Pending--
109INV-1108Redstone Marketing2025-09-04Paid2025-09-17
110INV-1109NovaTech Solutions2025-09-08Paid2025-09-30
111INV-1110Horizon IT Services2025-09-08Paid2025-09-22
112INV-1111Pinecrest Staffing2025-09-13Paid2025-10-03
113INV-1112NovaTech Solutions2025-09-16Pending--
114INV-1113Cloudline Software2025-09-17Pending--
115INV-1114Meridian Travel Co.2025-09-18Paid2025-10-11
116INV-1115Clearview Data Systems2025-09-19Paid2025-09-30
117INV-1116Cloudline Software2025-09-19Paid2025-10-01
118INV-1117Clearview Data Systems2025-09-19Paid2025-09-28
119INV-1118Greenfield Facilities2025-09-20Paid2025-10-15
120INV-1119Cloudline Software2025-09-21Paid2025-10-06
121INV-1120Horizon IT Services2025-09-21Paid2025-10-09
122INV-1121Meridian Travel Co.2025-09-21Paid2025-10-03
123INV-1122Redstone Marketing2025-09-24Paid2025-10-18
124INV-1123Redstone Marketing2025-09-25Overdue--
125INV-1124NovaTech Solutions2025-09-25Paid2025-10-16
126INV-1125Cloudline Software2025-09-25Paid2025-10-12
127INV-1126Meridian Travel Co.2025-09-25Paid2025-10-10
128INV-1127Horizon IT Services2025-10-03Overdue--
129INV-1128Forge & Frame Creative2025-10-04Paid2025-10-17
130INV-1129Cloudline Software2025-10-05Paid2025-10-22
131INV-1130BrightPath Analytics2025-10-05Paid2025-10-23
132INV-1131Keystone Legal Advisors2025-10-06Paid2025-10-23
133INV-1132BrightPath Analytics2025-10-10Paid2025-10-26
134INV-1133Meridian Travel Co.2025-10-11Paid2025-10-18
135INV-1134NovaTech Solutions2025-10-12Paid2025-10-30
136INV-1135Cloudline Software2025-10-21Paid2025-10-29
137INV-1136Greenfield Facilities2025-10-24Paid2025-11-07
138INV-1137Meridian Travel Co.2025-10-25Paid2025-11-12
139INV-1138Apex Office Supply2025-11-07Paid2025-11-20
140INV-1139Pinecrest Staffing2025-11-13Paid2025-11-29
141INV-1140Pinecrest Staffing2025-11-20Paid2025-12-09
142INV-1141Cloudline Software2025-11-21Paid2025-12-06
143INV-1142NovaTech Solutions2025-11-24Paid2025-12-05
144INV-1143Greenfield Facilities2025-12-09Paid2026-01-03
145INV-1144Clearview Data Systems2025-12-15Paid2026-01-05
146INV-1145Apex Office Supply2025-12-16Paid2025-12-25
147INV-1146Cloudline Software2025-12-18Paid2026-01-05
148INV-1147Summit Consulting Group2025-12-19Paid2026-01-12
149INV-1148NovaTech Solutions2025-12-19Paid2025-12-27
150INV-1149Greenfield Facilities2025-12-20Paid2026-01-13
151INV-1150Greenfield Facilities2025-12-23Pending--
152

Scroll to explore the table, then sort or filter by column as needed.

Hints

Your Answer

Exercise 2 of 2intermediate
#COUNTA-002

Question

How many invoices are missing a payment date? (Invoices without a payment date are likely still outstanding or need follow-up.)

Dataset

Vendor Spend Tracker (150 rows total)

Download CSV
Row numbersABCD
Header row
2INV-1001Cloudline SoftwarePaid2025-02-01
3INV-1002Apex Office SupplyPaid2025-01-25
4INV-1003Summit Consulting GroupPaid2025-02-10
5INV-1004Meridian Travel Co.Paid2025-02-15
6INV-1005Forge & Frame CreativePaid2025-02-20
7INV-1006NovaTech SolutionsPending--
8INV-1007Atlas Hardware Co.Paid2025-03-01
9INV-1008Clearview Data SystemsOverdue--
10INV-1009Redstone MarketingPaid2025-03-22
11INV-1010Keystone Legal AdvisorsPaid2025-03-28
12INV-1011Cloudline SoftwarePaid2025-01-18
13INV-1012Basecamp EventsPaid2025-02-01
14INV-1013Apex Office SupplyPaid2025-01-19
15INV-1014BrightPath AnalyticsPaid2025-02-01
16INV-1015Meridian Travel Co.Paid2025-01-29
17INV-1016Clearview Data SystemsPaid2025-01-29
18INV-1017Apex Office SupplyPaid2025-02-18
19INV-1018Summit Consulting GroupPaid2025-02-28
20INV-1019Cloudline SoftwarePaid2025-03-04
21INV-1020Atlas Hardware Co.Paid2025-03-19
22INV-1021Meridian Travel Co.Paid2025-03-17
23INV-1022Atlas Hardware Co.Pending--
24INV-1023Atlas Hardware Co.Paid2025-03-11
25INV-1024Apex Office SupplyPaid2025-03-19
26INV-1025Redstone MarketingPaid2025-03-22
27INV-1026Clearview Data SystemsPaid2025-03-31
28INV-1027Horizon IT ServicesPaid2025-03-30
29INV-1028Basecamp EventsPaid2025-04-06
30INV-1029Redstone MarketingPaid2025-04-03
31INV-1030BrightPath AnalyticsPaid2025-04-10
32INV-1031Basecamp EventsPaid2025-03-28
33INV-1032Cloudline SoftwarePaid2025-03-31
34INV-1033Clearview Data SystemsPending--
35INV-1034Meridian Travel Co.Paid2025-04-23
36INV-1035Cloudline SoftwarePaid2025-04-27
37INV-1036Horizon IT ServicesPaid2025-04-24
38INV-1037BrightPath AnalyticsPaid2025-04-15
39INV-1038Cloudline SoftwarePaid2025-04-20
40INV-1039Horizon IT ServicesPaid2025-04-30
41INV-1040Apex Office SupplyPaid2025-04-26
42INV-1041Summit Consulting GroupOverdue--
43INV-1042Clearview Data SystemsPaid2025-05-10
44INV-1043Forge & Frame CreativePaid2025-05-07
45INV-1044NovaTech SolutionsPaid2025-05-05
46INV-1045Meridian Travel Co.Paid2025-05-10
47INV-1046Cloudline SoftwarePaid2025-05-04
48INV-1047Apex Office SupplyPaid2025-04-29
49INV-1048Apex Office SupplyPaid2025-05-10
50INV-1049Pinecrest StaffingPaid2025-05-17
51INV-1050Clearview Data SystemsPaid2025-05-30
52INV-1051BrightPath AnalyticsOverdue--
53INV-1052Keystone Legal AdvisorsPaid2025-05-31
54INV-1053Cloudline SoftwarePaid2025-05-30
55INV-1054NovaTech SolutionsPaid2025-05-30
56INV-1055Basecamp EventsPaid2025-06-03
57INV-1056Cloudline SoftwarePaid2025-06-05
58INV-1057NovaTech SolutionsPaid2025-06-18
59INV-1058Clearview Data SystemsPaid2025-06-27
60INV-1059Basecamp EventsPaid2025-06-23
61INV-1060Horizon IT ServicesPaid2025-06-24
62INV-1061Atlas Hardware Co.Paid2025-06-17
63INV-1062Forge & Frame CreativePaid2025-06-22
64INV-1063Meridian Travel Co.Overdue--
65INV-1064Meridian Travel Co.Pending--
66INV-1065Cloudline SoftwarePaid2025-07-01
67INV-1066Redstone MarketingPaid2025-07-07
68INV-1067Horizon IT ServicesPaid2025-06-26
69INV-1068Cloudline SoftwarePaid2025-07-17
70INV-1069NovaTech SolutionsPaid2025-07-06
71INV-1070Apex Office SupplyPaid2025-07-11
72INV-1071Redstone MarketingPaid2025-07-22
73INV-1072NovaTech SolutionsOverdue--
74INV-1073Summit Consulting GroupPaid2025-07-22
75INV-1074Atlas Hardware Co.Paid2025-07-20
76INV-1075BrightPath AnalyticsPaid2025-07-31
77INV-1076Clearview Data SystemsPaid2025-07-22
78INV-1077Meridian Travel Co.Paid2025-07-21
79INV-1078Pinecrest StaffingPaid2025-07-19
80INV-1079Meridian Travel Co.Paid2025-07-20
81INV-1080Greenfield FacilitiesPaid2025-07-24
82INV-1081Keystone Legal AdvisorsPaid2025-08-05
83INV-1082Apex Office SupplyPaid2025-07-28
84INV-1083Cloudline SoftwarePaid2025-07-30
85INV-1084Meridian Travel Co.Paid2025-07-26
86INV-1085Horizon IT ServicesPaid2025-08-06
87INV-1086Cloudline SoftwarePaid2025-08-09
88INV-1087Apex Office SupplyPaid2025-08-17
89INV-1088Pinecrest StaffingPaid2025-08-16
90INV-1089NovaTech SolutionsPaid2025-08-20
91INV-1090Meridian Travel Co.Paid2025-08-21
92INV-1091Redstone MarketingPaid2025-08-24
93INV-1092Cloudline SoftwarePaid2025-08-27
94INV-1093Cloudline SoftwarePaid2025-08-23
95INV-1094BrightPath AnalyticsPaid2025-08-23
96INV-1095Redstone MarketingPaid2025-08-31
97INV-1096BrightPath AnalyticsPaid2025-08-26
98INV-1097Redstone MarketingPaid2025-09-06
99INV-1098Cloudline SoftwarePaid2025-08-29
100INV-1099Meridian Travel Co.Paid2025-09-08
101INV-1100Meridian Travel Co.Pending--
102INV-1101Forge & Frame CreativePaid2025-08-27
103INV-1102Atlas Hardware Co.Paid2025-08-28
104INV-1103NovaTech SolutionsPaid2025-08-27
105INV-1104Meridian Travel Co.Paid2025-09-12
106INV-1105NovaTech SolutionsPaid2025-08-31
107INV-1106Pinecrest StaffingOverdue--
108INV-1107Basecamp EventsPending--
109INV-1108Redstone MarketingPaid2025-09-17
110INV-1109NovaTech SolutionsPaid2025-09-30
111INV-1110Horizon IT ServicesPaid2025-09-22
112INV-1111Pinecrest StaffingPaid2025-10-03
113INV-1112NovaTech SolutionsPending--
114INV-1113Cloudline SoftwarePending--
115INV-1114Meridian Travel Co.Paid2025-10-11
116INV-1115Clearview Data SystemsPaid2025-09-30
117INV-1116Cloudline SoftwarePaid2025-10-01
118INV-1117Clearview Data SystemsPaid2025-09-28
119INV-1118Greenfield FacilitiesPaid2025-10-15
120INV-1119Cloudline SoftwarePaid2025-10-06
121INV-1120Horizon IT ServicesPaid2025-10-09
122INV-1121Meridian Travel Co.Paid2025-10-03
123INV-1122Redstone MarketingPaid2025-10-18
124INV-1123Redstone MarketingOverdue--
125INV-1124NovaTech SolutionsPaid2025-10-16
126INV-1125Cloudline SoftwarePaid2025-10-12
127INV-1126Meridian Travel Co.Paid2025-10-10
128INV-1127Horizon IT ServicesOverdue--
129INV-1128Forge & Frame CreativePaid2025-10-17
130INV-1129Cloudline SoftwarePaid2025-10-22
131INV-1130BrightPath AnalyticsPaid2025-10-23
132INV-1131Keystone Legal AdvisorsPaid2025-10-23
133INV-1132BrightPath AnalyticsPaid2025-10-26
134INV-1133Meridian Travel Co.Paid2025-10-18
135INV-1134NovaTech SolutionsPaid2025-10-30
136INV-1135Cloudline SoftwarePaid2025-10-29
137INV-1136Greenfield FacilitiesPaid2025-11-07
138INV-1137Meridian Travel Co.Paid2025-11-12
139INV-1138Apex Office SupplyPaid2025-11-20
140INV-1139Pinecrest StaffingPaid2025-11-29
141INV-1140Pinecrest StaffingPaid2025-12-09
142INV-1141Cloudline SoftwarePaid2025-12-06
143INV-1142NovaTech SolutionsPaid2025-12-05
144INV-1143Greenfield FacilitiesPaid2026-01-03
145INV-1144Clearview Data SystemsPaid2026-01-05
146INV-1145Apex Office SupplyPaid2025-12-25
147INV-1146Cloudline SoftwarePaid2026-01-05
148INV-1147Summit Consulting GroupPaid2026-01-12
149INV-1148NovaTech SolutionsPaid2025-12-27
150INV-1149Greenfield FacilitiesPaid2026-01-13
151INV-1150Greenfield FacilitiesPending--
152

Scroll to explore the table, then sort or filter by column as needed.

Hints

Your Answer

Want more practice?

Test Me mode randomizes exercises across all formulas without telling you which formula to use.

Try Test Me ->