Thread
:
Summary Sheet
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Summary Sheet
Hi John,
I am still having trouble visualising your data.
The Items are split into sections, at the bottom of each section there is
a
total for that day and a cumulative total.
Does this mean that you have a label at the bottom of each section saying
something like "Total Item 1"?
If so then with "Total Item 1" in A2 of your Summary sheet and dates in row
1 from B1 onwards then
=VLOOKUP($A$2,Sheet1!$A$1:$J$24,MATCH(B1,Sheet1!$A $1:$J$1,FALSE),FALSE)
worked for me.
If it will help you can send me a sample workbook with dummy data for
confidentiality
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"JohnM" wrote in message
...
Sory should have explained more
Items are in Col A
Dates Run across the columns D,E,F,G etc
The Items are split into sections, at the bottom of each section there is
a
total for that day and a cumulative total. These are what should be shown
o
the summary
Thanks
--
JohnM
"Sandy Mann" wrote:
John,
You don't say how your sheets are laid out so I am assuming that dates
ate
in Column A, Items in Column B and Amounts in Columns C.
For today's total for a Item 1:
=SUMPRODUCT((A1:A125=TODAY())*(B1:B125="Item 1")*(C1:C125))
For the Cumulative total for Item 1:
=SUMIF(B:B,"Item 1",C:C)
Note that SUMPRODUCT() cannot use whole columns but SUMIF() can.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"JohnM" wrote in message
...
I have a work sheet where I record daily costs for each item used.
I have a seperate summary sheet which I want to show that days cost for
an
item and a cumulative total for each item. I have tried VLookUp but
cannot
seem to get it to roll on each day
Any help would be appreciated
--
JohnM
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann