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