wildcards, SUMIF, and arrays
Posted by SJC on November 21, 2000 4:56 PM
Does anyone know how to create a formula to count the number of records if the records contain certain values? I have a small but growing spreadsheet that contains 3 columns. Column 1 lists products ("A", "B", "C", "A & B", "C& B", etc.). Column 2 lists names of Sales Rep. Column 3 lists sales volume. How do I get the total sales volume for product A (including the combos such as "A & B")? Unfortunately, the product type is growing so I can't sum up sales for A only and sales for A & B and then add the two. Thanks in advance for your help!