Help! Using excel 2010 starter

[Alpacino]

Hi everyone, I'm struggling to do a summary table using info from a table. The table has lists going down column A e.g. Row 1 (Sales), row 2(waste), row 3 (wages). Column 2 and so on has wk numbers in them with their actual figures in cells e.g. Wk 1 sales 45k wk 2 46k. What I would like to do is create a summary like vlookup??? to select Kpi and wk nber to give me the cell data. Anyone help??
Thanks in advance
Alpacino

 

[Jon von der Heyden]

You're welcome

Select the summary range.
Cut it (Control+X)
Go to the new sheet and choose a single cell where you want the summary to start from
Paste (Control+V)

 

[Alpacino]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Choose week	2
2	Choose KPI	Sales
3
4	Budget	759455
5	Actual	720507
6	RAG	R
7
8
9		1			2			3
10	KPI	Wk Bud	Wk Act	RAG	Wk Bud	Wk Act	RAG	Wk Bud	Wk Act	RAG
11	Sales	765086	725063	R	759455	720507	R			R
12	LFL	2	-4.49	R	2	-10.89	R	2		R
13	Waste	9674	9906	R	9663		G			R
...

Hi Jon its working a treat now! I wasnt changing the last number on the ROWS section.

finally I would like to count the number of Reds and green at the end of the period (4 wks sometimes 5 wks in a period) for each KPI and total!

Which function should I use??

Regards

Alan

 

[Alpacino]

Found it countif