Urgent SUMIF problem
Hi, I have this excel assignment and I'm having trouble with the 2 last 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;"PANASONI C";C9) - Total Units of non-SONY sold: =SUMIF(B6:B8;"<SONY";C6:C8)+SUMIF(B10;"<SONY";C1 0) 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, Matt +-------------------------------------------------------------------+ |Filename: My excel problem.doc | |Download: http://www.excelforum.com/attachment.php?postid=4831 | +-------------------------------------------------------------------+ -- MBAstudent ------------------------------------------------------------------------ MBAstudent's Profile: http://www.excelforum.com/member.php...o&userid=34993 View this thread: http://www.excelforum.com/showthread...hreadid=547317 |
All times are GMT +1. The time now is 08:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com