Reporting on cell information

[earnestwong]

Hi, i have an excel table with the following columns...

GBP, Euro, Date Raised

Exmple data for above columns...

GBP, Euro, Invoice Date Raised
£120, n/a, 14/01/2008
£90, n/a, 11/02/2008
n/a, €2345, 17/03/2008
£120, n/a, 14/01/2008
£120, n/a, n/a

I want a new worksheet at the bottom which will give a total for each month for each curreny if an invoice has been raised..

Something like...

Nov 07, Dec 07, Jan 08, Feb 08
GBP £1034, £3452, £900, n/a
Euro €234, €44, €3455, n/a


Please can someone show me how to do this??

many thanks,

Erny

 

[GlennUK]

What about a PivotTable for doing this?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[HarleyQuinn]

I'd have a look at a pivottable.

Data-->PivotTable and PivotChart Report

There's a wizard that will walk you through creating it.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.