Help With Formula
 

Hi all

This one is just a wee bit more than I can cope with

On worksheet WTW cell G2417 I would like to have a Formula
that would total from B103:IS103 currency on worksheet 'Budgets and Actuals'!
ONLY IF the equivalent Cells C6:IT6 on worksheet 'Date Details'! =USA.
i.e. if c6=usa then add B103,If D6= GB then do not add C103, IF E6=USA then
add d103 to running total

Any Hope

Thanks In advance

Stew

Help With Formula
 

=SUMIF(C6:G6,"usa",B12:F12)


On Feb 7, 7:26*pm, stew wrote:
*Hi all

This one is just a wee bit more than I can cope with

On worksheet WTW cell G2417 I would like to have a Formula
that would total from B103:IS103 currency on worksheet 'Budgets and Actuals'!
* * * *ONLY IF the equivalent Cells C6:IT6 on worksheet 'Date Details'! =USA.
i.e. if c6=usa then add B103,If D6= GB then do not add C103, IF E6=USA then
add d103 to running total

Any Hope

Thanks In advance

Stew

Help With Formula
 

Hi Muddan
Thanks for looking. Using what you gave me, which does not reflect the
Layout , I have adapted to this

=SUMIF('Date Details'!C6:IT6,"usa",'Budgets and Actuals'!B103:IS103)

This returns a #VALUE! error. Have I made a mistake in the construction.

"muddan madhu" wrote:

=SUMIF(C6:G6,"usa",B12:F12)


On Feb 7, 7:26 pm, stew wrote:
Hi all

This one is just a wee bit more than I can cope with

On worksheet WTW cell G2417 I would like to have a Formula
that would total from B103:IS103 currency on worksheet 'Budgets and Actuals'!
ONLY IF the equivalent Cells C6:IT6 on worksheet 'Date Details'! =USA.
i.e. if c6=usa then add B103,If D6= GB then do not add C103, IF E6=USA then
add d103 to running total

Any Hope

Thanks In advance

Stew

Help With Formula
 

On Feb 7, 5:26*pm, stew wrote:
*Hi all

This one is just a wee bit more than I can cope with

On worksheet WTW cell G2417 I would like to have a Formula
that would total from B103:IS103 currency on worksheet 'Budgets and Actuals'!
* * * *ONLY IF the equivalent Cells C6:IT6 on worksheet 'Date Details'! =USA.
i.e. if c6=usa then add B103,If D6= GB then do not add C103, IF E6=USA then
add d103 to running total

Any Hope

Thanks In advance

Stew

in cell WTW!G2417 type:
sumif( 'Date Details'!C6:IT6,"=USA",'Budgets and Actuals'!B103:IS103)-
if(D6="GB",C103,"")+if(E6="USA",D106,"")

Help With Formula
 

Sorry Rasoul, This does not Work

Thanks For Looking

Stew

"Rasoul Khoshravan" wrote:

On Feb 7, 5:26 pm, stew wrote:
Hi all

This one is just a wee bit more than I can cope with

On worksheet WTW cell G2417 I would like to have a Formula
that would total from B103:IS103 currency on worksheet 'Budgets and Actuals'!
ONLY IF the equivalent Cells C6:IT6 on worksheet 'Date Details'! =USA.
i.e. if c6=usa then add B103,If D6= GB then do not add C103, IF E6=USA then
add d103 to running total

Any Hope

Thanks In advance

Stew

in cell WTW!G2417 type:
sumif( 'Date Details'!C6:IT6,"=USA",'Budgets and Actuals'!B103:IS103)-
if(D6="GB",C103,"")+if(E6="USA",D106,"")

Help With Formula
 

try this one

=SUMPRODUCT(('Date Details'!C6:IT6="usa")*('Budgets and Actuals'!
B103:IS103))



On Feb 7, 8:59*pm, stew wrote:
Hi Muddan
Thanks for looking. Using what you gave me, which does not reflect the
Layout , I have adapted to this

=SUMIF('Date Details'!C6:IT6,"usa",'Budgets and Actuals'!B103:IS103)

This *returns a #VALUE! error. Have I made a mistake in the construction.