Look up date on another sheet and do count of active cells (column
It was probably the 256 that caused the problem if you start in column B
against column a as I did, so reduce it
=COUNT(OFFSET(Sheet2!B8,MATCH(TODAY(),Sheet2!B8:B3 9,0)-1,0,1,255))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"gary m" wrote in message
...
Bob:
Date only appears once. Dates are in column b only, b8 thru b39 for the
days
of the month. The sales by item for each date is next to it in columns C
thru
H, so for Jul1 the date would be in b8 and the numbers would be in c8 thru
H8. Below is how structured with total of six item columns. The formula
needs
to find the date and then count, in this case C8..H8 for July 1.
B C D E F G
H
Date Item 1 Item 2
7/1/06 322.00 300.00
7/2/06 312.00
Tried to apply your formula to this without success. Thanks for the help.
"gary m" wrote:
I have an Excel summary sheet that retrieves daily data from
departmental
sheets based on date search (eg. TODAY()-1,etc.. I need a formula that
will
go to the sheet, search for the date and then "Count" the cells in
columns
next to the date that have data. I have used vlookup to find specific
cells
but can't seem to 'count' multiple cells/columns next to the date. As
you can
see, I am somewhat an inexperienced user. Thanks for the help.
|