|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
May 12th, 2002, 05:44 PM
|
#1 |
|
New Member
Join Date: May 2002
Posts: 7
|
I need a formula to compare names in column a with letters in column b and if a match to sum the value in c.
a b c bill x 22 fred c 11 greg x 10 bill x 11 I need to sum column c when a=bill,b=x I should have a result of 33 with this example. I have tried several formulas but cannot get this result. I would appreciate any help! Thanks! |
|
|
|
May 12th, 2002, 05:50 PM
|
#2 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,317
|
Quote:
where E1 houses a value like bill and E2 a value like x. |
|
|
|
|
|
May 12th, 2002, 05:50 PM
|
#3 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Austin, Texas USA
Posts: 11,654
|
{=SUM((A1:A4="bill")*(B1:B4="x")*C1:C4)}
Note: This is an array formula which must be entered using the Control+Shift+Enter key combination. |
|
|
|
|
May 18th, 2002, 08:05 PM
|
#4 |
|
New Member
Join Date: May 2002
Posts: 7
|
My columns are on sheet 1. How do I reference the sheet in this sum product formula?
|
|
|
|
|
May 18th, 2002, 08:22 PM
|
#5 |
|
MrExcel MVP
Join Date: Apr 2002
Location: Vancouver BC , Canada
Posts: 6,259
|
EITHER PUT ON THE SAME SHEET OR ADD "SHEET1! TO THE FRONT OF YOUR RANGES
IE SHEET1!$A:$B Suggestion: To see the syntax go to another sheet , select cell , click = button then select another sheet... you will see the syntax auto built for you
__________________
<MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee> |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
