checkif/sumif question

[pswanie]

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

 

[Bernd P]

Hello,

If you do not want to use a pivot table I suggest to use one of my
UDFs Pfreq (together with Sfreq) or Pstat:
http://sulprobil.com/html/listfreq.html

Regards,
Bernd

 

[Paul]

Do you want to perform this with a pivot table, or is there something else
you need to do ?