CODEWITHSUNDEEP
excelexcel-formula
PinkstonMatt
PinkstonMatt

Reputation: 35

Excel Formula to Count

I have an excel workbook with two sheets - data & list

I want a formula for column N of the list sheet that will look at columns A through M of the list sheet and count how many times is matched in columns A through M of the data sheet.

Have tried the COUNTIFS() function with various conditions but can't search the range.

Upvotes: 0

Views: 150

Answers (1)

Kevin
Kevin

Reputation: 452

The COUNTIFS() function is used to calculate count according to more than one condition at the same time. Your case is to calculate the sum of cell counts that match one condition for each column using COUNTIF() function.

=COUNTIF(data!A:A,A2) + COUNTIF(data!B:B,B2) + COUNTIF(data!C:C,C2) + COUNTIF(data!D:D,D2) + COUNTIF(data!E:E,E2) + COUNTIF(data!F:F,F2) + COUNTIF(data!G:G,G2) + COUNTIF(data!H:H,H2) + COUNTIF(data!I:I,I2) + COUNTIF(data!J:J,J2) + COUNTIF(data!K:K,K2) + COUNTIF(data!L:L,L2) + COUNTIF(data!M:M,M2)

The formula will help you get cell counts that match A through M of the list sheet in A through M of the data sheet.

Upvotes: 1

Related Questions