S
Steved
Hello from Steved
I am getting a 0 value.
Ok I have 12 periods I am trying to get this to work for period 2.
From Charters "City - Panm" is Cell c27
From Charters "Period 2" is Cell A22
From Charters Cell C33 is the data I require, for worksheet named Kilometres
Planned.
SUM(IF('From Charters'!$C$1:$C$900="City - Panm",IF('From
Charters'!$A$1:$A$900="Period.2",'From Charters'!$C$33:$C$33,0),0))
What Have I not done please.
Thankyou
I am getting a 0 value.
Ok I have 12 periods I am trying to get this to work for period 2.
From Charters "City - Panm" is Cell c27
From Charters "Period 2" is Cell A22
From Charters Cell C33 is the data I require, for worksheet named Kilometres
Planned.
SUM(IF('From Charters'!$C$1:$C$900="City - Panm",IF('From
Charters'!$A$1:$A$900="Period.2",'From Charters'!$C$33:$C$33,0),0))
What Have I not done please.
Thankyou