IF , LOOKUP, Then SUM across rows

[Guest]

I'll try to explain this as well as my english permits...

(1) you could use the actual dates as the column headings;
Remember excel actually sees dates as numbers, so you
would be using numbers as the headings, but you could
display the month's names (by formating those cells) i.e,
instead of reading "Period 1", "Period 2", etc... you'll
be reading "Ene", "Feb", etc, with the proper formatting.

(2) Now the value of the cell A3 should also be a date...
i.e, a number formated to display as a date.

(3) finally, you can use a conditional sum, like this:

=SUMIF(B6:F6,"<="&A3)

that sould work... remember, dates are actually numbers...

-----Original Message-----
Hi There

I am trying to do the following........check to see which

month is in cell A3, then do a LOOKUP in column A to find

Hogs, and then SUM across that specific row to get a total.

So for example #1 --> I would like to find the SUM of

B6:E6 when the month is equal to April for Hogs.

If the month was March 31, 2003 , then I would like to

find the SUM of B66 for Hogs.

1 A B

C D E F