Excel Daily News

Using SUMIF for a table of values??

How do I use SUMIF when I want to sum the values that match a keyword (in column a) for a specific store location in row a. Table is 56 columns wide and about 25 rows deep.

store 1 2 5 7 16 27men menwomenwomen

Thanks...

Posted by Kevin James on May 04, 2001 8:41 AM

See incoming email

Posted by Aladin Akyurek on May 04, 2001 8:57 AM

Care to provide a 5 by 5 snippet of your data? You could activate an empty cell, type =, select an area of 5 by 5 of your data, and then hit CONTROL+SHIFT+ENTER at the same time. Go to the formula bar, select the formula and hit F9. Copy the array after = and paste it in the follow-up posting.

(6 responses) I'm part of an organisation that is altering the way it manages a waiting list, and we have decided we want a way of picking n people per ye

Let's Connect

MrExcel.com debuted on November 21, 1998.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on this
web site are provided "as is" and we do not guarantee that they can be used in all
situations.
This site contains affiliate links. Any affiliate commissions that we
earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com
running. You can earn a commission for sales leads that you send to us by joining our
affiliate program.
View my Privacy Policy and Terms of Use.