If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Count instances of text in date entries
Ah, the problem was I didn't use ctrl, shift and enter. Thanks very much.
"T. Valko" wrote: There's a typo in that formula. It's testing for January. For August, array entered** : =AVERAGE(IF((MONTH(B4:B21)=8)*(ISNUMBER(B4:B21)),D 421)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "dec697" wrote in message ... =AVERAGE(IF((MONTH(B4:B21)=1)*(ISNUMBER(B4:B21)),D 421)) I used the above formula and it didn't work. |
#12
|
|||
|
|||
Count instances of text in date entries
You're welcome!
-- Biff Microsoft Excel MVP "dec697" wrote in message ... Ah, the problem was I didn't use ctrl, shift and enter. Thanks very much. "T. Valko" wrote: There's a typo in that formula. It's testing for January. For August, array entered** : =AVERAGE(IF((MONTH(B4:B21)=8)*(ISNUMBER(B4:B21)),D 421)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "dec697" wrote in message ... =AVERAGE(IF((MONTH(B4:B21)=1)*(ISNUMBER(B4:B21)),D 421)) I used the above formula and it didn't work. |
|
Thread Tools | |
Display Modes | |
|
|