Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Identify date in 2 rows
Hi,
I am try to add up the number of entries in a column, only if there is another entry on the same row in another specified column. ie A B 1 x i 2 t 3 r 4 t The total for this would be 1. Many Thanks in advance |
#2
|
|||
|
|||
Hi,
Create a column C C1=if(and(A1<"",B1<""),1,0) C2=if(and(A2<"",B2<""),1,0) Similarly C3,C4... Sum(C1:C4..) give the required answer. Thanks, K.S.Warrier "dave" wrote: Hi, I am try to add up the number of entries in a column, only if there is another entry on the same row in another specified column. ie A B 1 x i 2 t 3 r 4 t The total for this would be 1. Many Thanks in advance |
#3
|
|||
|
|||
Hi
try =SUMPRODUCT(--(A1:A10<""),--(B1:B10<"")) "dave" wrote: Hi, I am try to add up the number of entries in a column, only if there is another entry on the same row in another specified column. ie A B 1 x i 2 t 3 r 4 t The total for this would be 1. Many Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Hiding rows based on date | Excel Worksheet Functions |