Michael at Thin Air Wrote:
I have a table that has columns of days, 1-31 and another column with
the day
of the week, Mon-Sun and then various columns of numbers for each day
of the
month.

I want to be able to a get sum of all the numbers for each day of the
week.
I am using lookup but this is only returning the last incidence and I
need
all the numbers added together. Example, I need all widgets sold on
Saturday
for the month.

TIA

If your days are in column B and he amounts you want to sum in column
C

=SUMIF(b:b,"Sat",c:c)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=506172