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