Count my KPI date , shift and line specific

[rodgerdooter]

hi all

im hoping someone can help me

im trying to make my life a whole lot easier by being able to see all my shift performance
i have something similar at the minute , but i really need to extend my analysis based on shift and line numbers

as you can see from the spread sheet , i have dates , lines and a whole load of numbers - currently i have it countng based on the date and the column
i could do with it looking for the date , shift and line and of course the date

on sheet 2 ideally all the numbers should populate from sheet 1 row d , and then populate all the days across on sheet 2

i hope all that makes sense

[Richard Buttrey]

Have you considered a Pivot Table that uses columns A:D on Sheet1?

See attached

[CARACALLA]

Sheet2


C3=F(AND(Sheet2!$A3<>"",Sheet2!C$2<>""),SUMIFS(Sheet1!$D$2:$D$100,Sheet1!$A$2:$A$100,Sheet2!C$2,Sheet1!$B$2:$B$100,Sheet2!$B3,Sheet1!$C$2:$C$100,Sheet2!$A3),"")

[rodgerdooter]

ive never really used pivot tables :-(

my intention is to count all the rows , then make graphs which will populate a dashboard

can a pivot table do that ?

[rodgerdooter]

Sheet2


C3=F(AND(Sheet2!$A3<>"",Sheet2!C$2<>""),SUMIFS(Sheet1!$D$2:$D$100,Sheet1!$A$2:$A$100,Sheet2!C$2,Sheet1!$B$2:$B$100,Sheet2!$B3,Sheet1!$C$2:$C$100,Sheet2!$A3),"")

i cant seen to get that formula working , it just comes up with "name "

[CARACALLA]

Try this

Sorry

Sheet2

C3=IF(AND(Sheet2!$A3<>"",Sheet2!C$2<>""),SUMIFS(Sheet1!$D$2:$D$100,Sheet1!$A$2:$A$100,Sheet2!C$2,Sheet1!$B$2:$B$100,Sheet2!$B3,Sheet1!$C$2:$C$100,Sheet2!$A3),"")

copy across and down

[rodgerdooter]

Try this

Sorry

Sheet2

C3=IF(AND(Sheet2!$A3<>"",Sheet2!C$2<>""),SUMIFS(Sheet1!$D$2:$D$100,Sheet1!$A$2:$A$100,Sheet2!C$2,Sheet1!$B$2:$B$100,Sheet2!$B3,Sheet1!$C$2:$C$100,Sheet2!$A3),"")

copy across and down

my bad , i didnt notice the I missing either:-)

[Richard Buttrey]

A Pivot Table has a default Pivot Chart attached. It will show if you put the cursor in the Pivot Table and then select Pivot Chart from the PT menu.