Formula Help

[Janet]

We have 11 pens in which to feed cattle. Each pen is fed
every day, and the amount fed to each pen is recorded each
day. To keep track, I am creating a spreadsheet that has
11 categories, and data entry for a year. Column A is my
date range. (A2 = July 1, 2003; A367 = June 30, 2003).
For each of the 11 categories, I have four columns of
info. The first is kg of feed fed, the second is type of
feed fed, the third is the last 5 days average, and the
fourth is the last 28 days average.

On another sheet, I want to do some analysis of the data.
I want the second sheet to be updated every day, so that
if a customer visits, I can hit a button and show him all
the info on his individual pen of cattle. So this second
sheet needs to automatically show 5-day average
consumption and 28-day average consumption.

So basically, I need it to scan column A on my first sheet
till it hits "today," then fill in the 5-day and 28-day
numbers. I know this is very simple, I just cannot figure
out the formula for scanning through column A for today's
date.

I hope someone can help me do this! I'm almost finished
with this project, and this will be the capstone.

Thanks bunches,
Janet

 

[Bob Phillips]

Janet,

Use
=INDIRECT("C"&MATCH(TODAY(),A1:A367,0))

=INDIRECT("D"&MATCH(TODAY(),A1:A367,0))

 

[Jan]

Have you tried CSE using SUMIF? If you key off the date,
it will only find the single value in column of interest.