How can I add up lookups? Finding days in a week of a month

[Michael at Thin Air]

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

 

[Anne Troy]

Try this, Michael:
http://www.officearticles.com/excel/sumif_using_a_cell_reference_as_criteria_in_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Anne Troy]

Sorry! Wrong link. Here it is:
http://www.officearticles.com/excel/sumif_with_dates_in_microsoft_excel.htm
(Didn't have my coffee yet.)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Debra Dalgleish]

An easy way to summarize data in a table is to use a pivot table. There
are instructions in Excel's Help, and here:

http://www.contextures.com/xlPivot01.html

In the pivot table, put Day in the row area, and the number columns in
the Data area.

 

[JMB]

Another link that may be useful to you regarding multiple criteria lookups

http://xldynamic.com/source/xld.SUMPRODUCT.html

 

[daddylonglegs]

I have a table that has columns of days, 1-31 and another column wit
the day
of the week, Mon-Sun and then various columns of numbers for each da
of the
month.

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

TIA

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

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