Sum formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am puzzled on how to write a sum formula for the following
(from a very large entry form that somebody else designed with data validation
which only allows "X") in the size column.

A B C D E F
Red Navy Pewter Small Medium Large
2 X

How do i get a total of small red shirts from a formula ?

Steve
 
Does the number (2 in this case) in columns A-C represent
the number to order for that color? If so, try:

=SUMIF(D:D,"x",A:A)

To sum the total small red shirts.

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top