count the number of times data appears on the same row from two c.

G

GavT9

I have two collums of data. I want to count the number of times there is an
outcome in both collumns. How many rows have an outcome in both collumns.
 
M

Max

Assuming the source data is in cols A and B, row1 down
you could try in say, C1:

=SUMPRODUCT((TRIM(A1:A10)<>"")*(TRIM(B1:B10)<>""))

Adapt the ranges: A1:A10, B1:B10 to suit. The ranges need to be identically
structured, and you can't use entire col references (A:A, B:B) in SUMPRODUCT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting rows based on the contents of multiple cells 2
VLOOKUP help needed.!! 3
comapering two sheets in excel 2010 0
How to count the numbers in a Word document? 0
Function in Excel to count and list number of entries of text valuesin a row. 2
Counting sets of cells based on two parameters 4
Format column widths from one table to a separate table on same page 1
Get data from specific collumn 4

Top