| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
count the number of times data appears on the same row from two c.
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. |
|
#2
|
|||
|
|||
|
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 -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "GavT9" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of days in given month? | Excel Worksheet Functions | |||
| How do I limit the number of times an Excel workbook can be opene. | Excel Discussion (Misc queries) | |||
| Count number of row where are data | Excel Discussion (Misc queries) | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
Linear Mode
