Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count in a variable range
I am trying to count the number of "W"s entered into a row (e.g. row 8).
Row 7 has the days of each month (i.e. 1 thro' 28, 30, 31 as appropriate) each number is entered in two merged cells (identifies a.m & p.m. in the rows below) Cell E2 contains a date Using a formula, I need to count the "W"s in a range between a (first cell) variable column row 8 and GW8 (formula will be copied down) The variable first cell is dependent upon the date (E2) thus using =ADDRESS(8,MATCH(DAY(E2),A7:AP7,0),4) will result in the correct cell for the beginning of the range. =COUNTIF(AM8:GW8,"W") works perfectly, however when the two are incorporated thus =COUNTIF(ADDRESS(8,MATCH(DAY(E2),A7:AP7,0),4):GW8, "W") I am told "The formula I typed contains an error". Any ideas what am I doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count if multiple variable exist | Excel Discussion (Misc queries) | |||
Multiple Variable Count problem | Excel Worksheet Functions | |||
from Range variable | Excel Discussion (Misc queries) | |||
from Range variable | Charts and Charting in Excel | |||
How to use a variable for a range | Excel Worksheet Functions |