Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong with my formula? Excel 2000.
Sheet 1 has an X column that has dates. It also has column BD that has a
"Yes" or "No" entered in it. The cell range is from 2-221. On sheet 2, I want to count the number of "no" entries in BD for only the records where the date in X is greater than 1/1/2006. My formula is this : =COUNTIF(Sheet1!X2:X221,"1/1/2006",Sheet1!BD2:BD221,"no") I can get the countif function to do each separately, but I don't know how to combine the two. Help! Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong with my formula? Excel 2000.
Try this:
=SUMPRODUCT(--(Sheet1!X2:X221DATE(2006,1,1)),--(Sheet1!DB2:DB221="no")) Or, it's better (more versatile) if you use cells to hold the criteria: A1 = 1/1/2006 A2 = no =SUMPRODUCT(--(Sheet1!X2:X221A1),--(Sheet1!DB2:DB221=A2)) Biff "HWhite" wrote in message ... Sheet 1 has an X column that has dates. It also has column BD that has a "Yes" or "No" entered in it. The cell range is from 2-221. On sheet 2, I want to count the number of "no" entries in BD for only the records where the date in X is greater than 1/1/2006. My formula is this : =COUNTIF(Sheet1!X2:X221,"1/1/2006",Sheet1!BD2:BD221,"no") I can get the countif function to do each separately, but I don't know how to combine the two. Help! Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong with my formula? Excel 2000.
=SUMPRODUCT(--(Sheet1!X2:X221--"1/1/2006"),--(Sheet1!BD2:BD221="no"))
"HWhite" wrote: Sheet 1 has an X column that has dates. It also has column BD that has a "Yes" or "No" entered in it. The cell range is from 2-221. On sheet 2, I want to count the number of "no" entries in BD for only the records where the date in X is greater than 1/1/2006. My formula is this : =COUNTIF(Sheet1!X2:X221,"1/1/2006",Sheet1!BD2:BD221,"no") I can get the countif function to do each separately, but I don't know how to combine the two. Help! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 Formula Not Working Other Users | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula Integrity Not Preserved During Sort in Excel 2000 | Excel Discussion (Misc queries) |