| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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,"") |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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,"") |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
