Hi...
I am working on an Excel project (Excel 2003) wherein I have to pull data from other Excel sheet.
I have to count one field based on other field...
Field 1 : Yes/No
Field 2 : Date
Now, I want to count all the "Yes" from Field 1 based on Field 2
I have used below formula (as seen somewhere):
=Sum(([Book1]Field 1!A:A="Yes")*([Book1]Field2!B:B=D9))
Where D9 is the reference for the date in the active table (the table in which the present formula is incorporated)
But, no matter what, the result is always showing as zero...
Any help on this matter as to how to crack this multi-conditional counting.
Note: This is quite possible in Excel 2007 with the function COUNTIFS,but I want this to be cracked in Excel 2003.
The formula written over here may not be correct in its syntax as I have manually typed the formula.
Desperately awaiting for your help...
I am working on an Excel project (Excel 2003) wherein I have to pull data from other Excel sheet.
I have to count one field based on other field...
Field 1 : Yes/No
Field 2 : Date
Now, I want to count all the "Yes" from Field 1 based on Field 2
I have used below formula (as seen somewhere):
=Sum(([Book1]Field 1!A:A="Yes")*([Book1]Field2!B:B=D9))
Where D9 is the reference for the date in the active table (the table in which the present formula is incorporated)
But, no matter what, the result is always showing as zero...
Any help on this matter as to how to crack this multi-conditional counting.
Note: This is quite possible in Excel 2007 with the function COUNTIFS,but I want this to be cracked in Excel 2003.
The formula written over here may not be correct in its syntax as I have manually typed the formula.
Desperately awaiting for your help...
