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

"Steved" wrote:

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

Try
SUM(IF(AND('From Charters'!$C$1:$C$900="City - Panm",'From
Charters'!$A$1:$A$900="Period.2"),'From Charters'!$C$33:$C$33,0),0)

And enter with Ctrl+Shift+Enter

Peter

Hello Peter from Steved

Firstly thanks for your time on my issue.

I am still getting a 0 Value.

HLOOKUP($A$3,'From Charters'!$A$7:$I$300,7,0)

works on the first, I tried to see if I can fiqure out what I need for it to
reconize the other 11 periods, hence the reasoning for the earlier formula.

Hoping the above is helpful

Once Again thankyou.

"PeterAtherton" wrote:



"Steved" wrote:

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

Try
SUM(IF(AND('From Charters'!$C$1:$C$900="City - Panm",'From
Charters'!$A$1:$A$900="Period.2"),'From Charters'!$C$33:$C$33,0),0)

And enter with Ctrl+Shift+Enter

Peter

Hello From Steved

I got it working.

"Steved" wrote:

Hello Peter from Steved

Firstly thanks for your time on my issue.

I am still getting a 0 Value.

HLOOKUP($A$3,'From Charters'!$A$7:$I$300,7,0)

works on the first, I tried to see if I can fiqure out what I need for it to
reconize the other 11 periods, hence the reasoning for the earlier formula.

Hoping the above is helpful

Once Again thankyou.

"PeterAtherton" wrote:



"Steved" wrote:

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

Try
SUM(IF(AND('From Charters'!$C$1:$C$900="City - Panm",'From
Charters'!$A$1:$A$900="Period.2"),'From Charters'!$C$33:$C$33,0),0)

And enter with Ctrl+Shift+Enter

Peter