Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checkif/sumif question
Hi
I have a sheet with names scrambled in sheet1.column A down. column B down dates, C down items bought, d down price per item. I want to hit a button and have it summarised on sheet 2. for example... Emp1 29/12/09 pie 12.50 emp2 2912/09 juice 4.50 emp1 30/12/09 cake 9.50 emp3 27/12/09 fruit 10.50 emp1 25/12/09 pie 12.50 emp1 30/12/09 cake 9.50 emp1 29/12/09 juice 4.50 the summary should look like this emp1 25/12/09 pie 1 12.50 29/12/09 pie 1 12.50 juice 1 4.50 30/12/09 cake 2 19.00 emp2 29/12/09 juice 1 4.50 emp3 27/12/09 fruit 1 10.50 -- Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif + right question | Excel Worksheet Functions | |||
SUMIF question | Excel Worksheet Functions | |||
Sumif Question? | Excel Discussion (Misc queries) | |||
Another SUMIF question | Excel Worksheet Functions | |||
Sumif question | Excel Worksheet Functions |