I would like it to go through and display all values in a column once with the totals for that category, is this even possible in excel?

[whereskris]

Hi I have data laid out like below,
I am trying to write a formula to go through 1000's of rows in column B (Category) then display all of the records once and add up the totals
e.g. CCON $123.04
COTH $456.06

I have been able to do this with =SUMIFS(U27:U10000,F27:F10000,"="&I11,I27:I10000,"<="&J7,I27:I10000,">="&J6)
But I haven't been able to do it dynamically I have to actually type CCON in a cell for it to search for matches, I would like it to go through and display all values in a column once with the totals for that category, is this even possible?

Even better if possible then to display the above but between a start and end date entered in separate cells lets say A1 and A2

Project ID	Category	Resource Category Description	Acctg Date	Description	Journal ID	Vendor Name	Transaction Amount $
683234	CCON	Consultants	07/31/2014	PMO Alloc June 2014	WG140703	n/a	4,721
683234	CCON	Consultants	05/09/2014	PMO Alloc Apr 2014	LM0358	n/a	6,407
683234	CCON	Consultants	06/19/2014	PMO Alloc May 2014	WG20140613	n/a	154
683234	CCON	Consultants	05/09/2014	PMO Alloc Apr 2014	LM0358	n/a	203
683234	CCON	Consultants	04/01/2014	Tfr 474001 Mar 2014	LM0336	n/a	107
683234	COTH	Contractors - Other	11/18/2014	As per Quotation 7AU-703000710	AP00248634	GE Energy Measurement & Control Pty Ltd	38,770
683234	COTH	Contractors - Other	04/01/2014	Under contract 002-2103. Contr	AP00237600	GE Energy Measurement & Control Pty Ltd	463,536
683234	COTH	Contractors - Other	06/10/2014	Progress payment #2 upon Submi	AP00240681	GE Energy Measurement & Control Pty Ltd	463,536
683234	COTH	Contractors - Other	06/24/2014	Progress payment #3 Upon Procu	AP00241322	GE Energy Measurement & Control Pty Ltd	231,768
683234	COTH	Contractors - Other	10/08/2014	Progress payment #5 Upon Mobil	AP00246648	GE Energy Measurement & Control Pty Ltd	77,256
683234	COTH	Contractors - Other	09/26/2014	Accrue Unmatched PO Receipts	PO00246123	n/a	77,256
683234	COTH	Contractors - Other	10/01/2014	Accrue Unmatched PO Receipts	PO00246124	n/a	(77,256)
683234	COTH	Contractors - Other	11/07/2014	Progress payment #4 Upon Shipm	AP00248166	GE Energy Measurement & Control Pty Ltd	154,512
683234	COTH	Contractors - Other	10/31/2014	Accrue Unmatched PO Receipts	PO00247694	n/a	154,512
683234	COTH	Contractors - Other	10/31/2014	WIP SysAssets Internallyfunded	0000247865	n/a	0
683234	COTH	Contractors - Other	10/31/2014	WIP SysAssets Internallyfunded	0000247866	n/a	154,512
683234	COTH	Contractors - Other	11/01/2014	Accrue Unmatched PO Receipts	PO00247695	n/a	(154,512)
683234	COTH	Contractors - Other	11/01/2014	WIP SysAssets Internallyfunded	0000247865	n/a	0

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[gaz_chops]

Try Pivot Table.

 

[whereskris]

Thanks Gaz chops, but I would like to dump the data in one tab, changes from project to project and do it by formula to populate a dashboard.
I haven't had anything to do with pivot tables so probably should learn them and see if it can accomplish what I need, I am thinking it will make it necessat to add another tab to my sheet that's all.
ie. p6_dump, p6_pivot_table, managers_report amonst many others