Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blank Check?
Please could someone help me with this problem?
The formula in cells of column D must check 'Week Number' (column A) to see if it is blank. If it is blank then the cell in column D should remain blank (no value). If the value in 'Week Number' (column A) matches the value in 'Week' (column C), then the number of cells in 'Yes?' (column B) with a value of 'Y' must be summed up and entered in the corresponding cell of 'Total' (column D). For example: Cells A2:A5 match cell C1. Therefore, the number of 'Y's in cells B2:B5 must be totalled-up and the resulting value (number) is to be entered in cell D2 (the result of the formula in cell D2. I am using Excel 2003. If you would like me to send a sample file, please let me know. I really would appreciate any help you can give. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blank Check?
PlutoNash -
Try this: =SUMPRODUCT(--(A1:A13 = C1),--(B1:B13 = "Yes")) -- Daryl S "PlutoNash" wrote: Please could someone help me with this problem? The formula in cells of column D must check 'Week Number' (column A) to see if it is blank. If it is blank then the cell in column D should remain blank (no value). If the value in 'Week Number' (column A) matches the value in 'Week' (column C), then the number of cells in 'Yes?' (column B) with a value of 'Y' must be summed up and entered in the corresponding cell of 'Total' (column D). For example: Cells A2:A5 match cell C1. Therefore, the number of 'Y's in cells B2:B5 must be totalled-up and the resulting value (number) is to be entered in cell D2 (the result of the formula in cell D2. I am using Excel 2003. If you would like me to send a sample file, please let me know. I really would appreciate any help you can give. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check for Non Blank and Blank Cells Before Save | Excel Discussion (Misc queries) | |||
Macro to check if clipboard is blank. | Excel Discussion (Misc queries) | |||
Check for blank clipboard | Excel Discussion (Misc queries) | |||
How to check for blank cells with formula | Excel Discussion (Misc queries) | |||
check for two blank cells before populating a 3rd. | Excel Worksheet Functions |