I copied an Excel spreadsheet to GoogleDocs, and it blew up a couple of formulas because they're arrays, I suppose. On taking their direction using =ArrayFormula(FormulaHere), it didn't work.
I am trying to COUNTIF between date1 and date2 in column C of multiple worksheets. My formula worked in Excel. Here it is.
=SUMPRODUCT(--INDIRECT(E5&"!$d$3:$d$1000000")>=B4,--INDIRECT(E5&"!$d$3:$d$1000000")<=$B$2)
Also, E5 contained a person's first name, where that first name is the Sheet name. I'd rather not type each formula individually.
Any help is greatly appreciated. Have any of you done the GoogleDocs thang?
Great forum, Ken. THANKS!!!
I am trying to COUNTIF between date1 and date2 in column C of multiple worksheets. My formula worked in Excel. Here it is.
=SUMPRODUCT(--INDIRECT(E5&"!$d$3:$d$1000000")>=B4,--INDIRECT(E5&"!$d$3:$d$1000000")<=$B$2)
Also, E5 contained a person's first name, where that first name is the Sheet name. I'd rather not type each formula individually.
Any help is greatly appreciated. Have any of you done the GoogleDocs thang?
Great forum, Ken. THANKS!!!