If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sumif and vlookup Help
Can you please help me with setting up a formula?
Product A = $100 Product A = $100 Product A = $300 I want my result to be Product A = $500 not $100. Please help...Thanks |
#2
|
|||
|
|||
Sumif and vlookup Help
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Nikki" wrote in message ... Can you please help me with setting up a formula? Product A = $100 Product A = $100 Product A = $300 I want my result to be Product A = $500 not $100. Please help...Thanks |
#3
|
|||
|
|||
Sumif and vlookup Help
Hi Nikki
Maybe this : =SUMPRODUCT((A1:A7="Product A")*(B1:B7)) You need to adjust the range to your needs. HTH John "Nikki" wrote in message ... Can you please help me with setting up a formula? Product A = $100 Product A = $100 Product A = $300 I want my result to be Product A = $500 not $100. Please help...Thanks |
Thread Tools | |
Display Modes | |
|
|