Help With Formula

[stew]

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

 

[muddan madhu]

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

 

[stew]

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.

 

[Rasoul Khoshravan]

 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,"")

 

[stew]

Sorry Rasoul, This does not Work

Thanks For Looking

Stew

 

[muddan madhu]

try this one

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