Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Yet Another 'INDIRECT' Question
=COUNT('Other'!$B$4)+SUMPRODUCT(--('Other'!$A$16:$A$21="OCT")*ISNUMBER('Other'!$B$16 :$B$21))
'Other'!B4 is the October date of an Excellent rating 'Other'!A16:A21 *might* contain "OCT" -- if it does... 'Other'!B16:B21 contains the date(s) of additional October Excellent ratings The formula above is on the compilation worksheet "OCT" Problem: When users copy or drag dates on the "Other" worksheet to another cell, I wind up with errors on the "OCT" worksheet. I believe the Indirect formula is the way to go, but I can't get it to work (the formula is accepted but doesn't give me the number of Excellent ratings) Thanks -- Suzanne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT Question | Excel Discussion (Misc queries) | |||
INDIRECT Question I think | Excel Discussion (Misc queries) | |||
Question on INDIRECT | Excel Discussion (Misc queries) | |||
Indirect question | Excel Discussion (Misc queries) | |||
indirect.ext question | Excel Discussion (Misc queries) |