Urgent SUMIF problem

[MBAstudent]

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;"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,

Matt

[Ardus Petus]

You may ignore the merged cells in row 8, and write:
=SUMIF(B$5:B$9;"PANASONIC";C$5:C$9) for PANASONIC units

Same for non-SONY units:
=SUMIF(B$5:B$9;"<>SONY";C$5:C$9)


See example: http://cjoint.com/?gbhTxLbPgB

HTH
--
AP

"MBAstudent" <[email protected]> a
écrit dans le message de news:
[email protected]...
>
> 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;"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,
>
> 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
>