Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble with formula
For some reason, I am having trouble getting this to work. Created the
following formula: =SUMPRODUCT(('Incoming Cores'!A1:A4="Duncan")+('Incoming Cores'!A1:A4="Simplet"))*'Incoming Cores'!B1:E4) The actual spreadsheet covers a much larger area. Simply wanting the sum of the Duncan and Simplet rows. Can anyone see what I have down wrong? a b c d e 1 smith 33 44 55 66 2 Duncan 45 56 45 38 3 Simplet 74 65 26 67 4 Duncan 6 78 67 69 -- Bruce |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble with formula
=SUMPRODUCT(((A1:A4="Duncan")+(A1:A4="Simplet"))*B 1:C4)
You were missing a parenthesis near the beginning. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bruce Benaway" wrote: For some reason, I am having trouble getting this to work. Created the following formula: =SUMPRODUCT(('Incoming Cores'!A1:A4="Duncan")+('Incoming Cores'!A1:A4="Simplet"))*'Incoming Cores'!B1:E4) The actual spreadsheet covers a much larger area. Simply wanting the sum of the Duncan and Simplet rows. Can anyone see what I have down wrong? a b c d e 1 smith 33 44 55 66 2 Duncan 45 56 45 38 3 Simplet 74 65 26 67 4 Duncan 6 78 67 69 -- Bruce |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble with formula
Thanks much, it worked. Have a general question as this has happened to me
before. How do you know when one, two or three parenthesis are needed before and after some of these formulas. Thanks again. -- Bruce "Luke M" wrote: =SUMPRODUCT(((A1:A4="Duncan")+(A1:A4="Simplet"))*B 1:C4) You were missing a parenthesis near the beginning. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bruce Benaway" wrote: For some reason, I am having trouble getting this to work. Created the following formula: =SUMPRODUCT(('Incoming Cores'!A1:A4="Duncan")+('Incoming Cores'!A1:A4="Simplet"))*'Incoming Cores'!B1:E4) The actual spreadsheet covers a much larger area. Simply wanting the sum of the Duncan and Simplet rows. Can anyone see what I have down wrong? a b c d e 1 smith 33 44 55 66 2 Duncan 45 56 45 38 3 Simplet 74 65 26 67 4 Duncan 6 78 67 69 -- Bruce |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble with formula
It's not a question of how many parentheses "before" or "after" a formula.
The first thing to remember is that parentheses come in pairs, so you need the same number of opening parentheses as closing. You had 3 opening and 4 closing, so Excel will have told you that the formula was not valid. You just need to think about what you are trying to do, and in what order. The SUMPRODUCT function encloses its parameters in parentheses, so that is your outside pair. You wanted to multiply B1:E4 by another term, so the other term goes in another pair of parentheses to force it to be calculated before the multiplication. That term was to be calculated by adding your two terms dependent on A1:A4, so each of these is calculated first (by being put in another pair of parentheses) before being added. -- David Biddulph "Bruce Benaway" wrote in message ... Thanks much, it worked. Have a general question as this has happened to me before. How do you know when one, two or three parenthesis are needed before and after some of these formulas. Thanks again. -- Bruce "Luke M" wrote: =SUMPRODUCT(((A1:A4="Duncan")+(A1:A4="Simplet"))*B 1:C4) You were missing a parenthesis near the beginning. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bruce Benaway" wrote: For some reason, I am having trouble getting this to work. Created the following formula: =SUMPRODUCT(('Incoming Cores'!A1:A4="Duncan")+('Incoming Cores'!A1:A4="Simplet"))*'Incoming Cores'!B1:E4) The actual spreadsheet covers a much larger area. Simply wanting the sum of the Duncan and Simplet rows. Can anyone see what I have down wrong? a b c d e 1 smith 33 44 55 66 2 Duncan 45 56 45 38 3 Simplet 74 65 26 67 4 Duncan 6 78 67 69 -- Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula trouble | Excel Discussion (Misc queries) | |||
trouble with formula | Excel Discussion (Misc queries) | |||
still having trouble with this formula | Excel Discussion (Misc queries) | |||
Trouble with my formula | Excel Discussion (Misc queries) | |||
I'm new at this - having trouble with a formula | Excel Discussion (Misc queries) |