Count #s in One Range If Text In Another Range is Equal or Not Equal to Specific Text

**MLCall** · 12-12-2012, 11:52 AM

I am using Excel 2010. I need to calculate two totals from the numbers in one range, depending on if the text in another range is equal or not equal to specific text. The first total from the first range is based on if the text in the 2nd range is equal to Elgin. The second total from the first range is based on if the text in the 2nd range is not equal to Elgin.

I know I can resort the data to get the totals I need but I am sure that there is a formula that can give me the desired results.

Any suggestions? I'd really appreciate some help.

Thanks, MLCall

**Moo the Dog** · 12-12-2012, 11:56 AM

I hope this is what you were looking for:

To sum column A values when column B = Elgin, try this:
=SUMIF($B$1:$B$10,"Elgin",$A$1:$A$10)

To sum column A values when column B <> Elgin, try this:
=SUMIF($B$1:$B$10,"<>Elgin",$A$1:$A$10)

Adjust ranges to suit your needs.

- Moo

**MLCall** · 12-12-2012, 12:29 PM

Moo,

This worked great. I appreciate your help. I added to your rep!

MLCall

**Moo the Dog** · 12-12-2012, 12:30 PM

Thank you, ML. It is always appreciated!
Glad I could help.

- Moo

Count #s in One Range If Text In Another Range is Equal or Not Equal to Specific Text

LinkBack

Thread Tools

Rate This Thread

Display

Count #s in One Range If Text In Another Range is Equal or Not Equal to Specific Text

Re: Count #s in One Range If Text In Another Range is Equal or Not Equal to Specific Text

Re: Count #s in One Range If Text In Another Range is Equal or Not Equal to Specific Text

Re: Count #s in One Range If Text In Another Range is Equal or Not Equal to Specific Text

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions