Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum formula
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 |
#2
|
|||
|
|||
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 -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |