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

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

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

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

"Michael at Thin Air" wrote in
message ...
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

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

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

"Michael at Thin Air" wrote in
message ...
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

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

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

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

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

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

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

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

"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

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

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