M
MBAstudent
Hi,
I have this excel assignment and I'm having trouble with the 2 las
questions:
- Total non-SONY sales ($):
- Total SONY sales ($):
Could you also confirm the other 2 formulas I wrote?
- Total Units of PANASONIC sold:
=SUMIF(B5:B7;"PANASONIC";C5:C7)+SUMIF(B9;"PANASONIC";C9)
- Total Units of non-SONY sold:
=SUMIF(B6:B8;"<>SONY";C6:C8)+SUMIF(B10;"<>SONY";C10)
I copied my excel chart to word in the attached document
A B C D
E
4 DAY BRAND UNITS SOLD UNIT PRICE BOROUGH
5 Mon. SONY 6 $500,00 Queens
6 Tue. PANASONIC 5 $400,00 Bronx
7 Wed. ZENITH 20 $200,00 Brooklyn
8 Thurs. CLOSED FOR NATIONAL HOLIDAY
9 Fri. SONY 40 $500,00 Bronx
Total Units of PANASONIC sold: 5
Total Units of non-SONY sold: 25
Total non-SONY sales ($):
Total SONY sales ($):
If I could have an answer before the June 3rd that would be great !!!
Thanks,
Mat
+-------------------------------------------------------------------
|Filename: My excel problem.doc
|Download: http://www.excelforum.com/attachment.php?postid=4831
+-------------------------------------------------------------------
I have this excel assignment and I'm having trouble with the 2 las
questions:
- Total non-SONY sales ($):
- Total SONY sales ($):
Could you also confirm the other 2 formulas I wrote?
- Total Units of PANASONIC sold:
=SUMIF(B5:B7;"PANASONIC";C5:C7)+SUMIF(B9;"PANASONIC";C9)
- Total Units of non-SONY sold:
=SUMIF(B6:B8;"<>SONY";C6:C8)+SUMIF(B10;"<>SONY";C10)
I copied my excel chart to word in the attached document
A B C D
E
4 DAY BRAND UNITS SOLD UNIT PRICE BOROUGH
5 Mon. SONY 6 $500,00 Queens
6 Tue. PANASONIC 5 $400,00 Bronx
7 Wed. ZENITH 20 $200,00 Brooklyn
8 Thurs. CLOSED FOR NATIONAL HOLIDAY
9 Fri. SONY 40 $500,00 Bronx
Total Units of PANASONIC sold: 5
Total Units of non-SONY sold: 25
Total non-SONY sales ($):
Total SONY sales ($):
If I could have an answer before the June 3rd that would be great !!!
Thanks,
Mat
+-------------------------------------------------------------------
|Filename: My excel problem.doc
|Download: http://www.excelforum.com/attachment.php?postid=4831
+-------------------------------------------------------------------