Blank Check?

P

PlutoNash

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
use month in cell date to sum all relevant cells 2
Excel Concatenate with line breaks but ignore blank cells 3
Help needed 0
Event recognition. 6
Function based on blank cell and date past due 11
help with formula for last input in column 6
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1

Top