Help With Formula

S

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
 
S

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.
 
R

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

muddan madhu

try this one

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top