| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Use the sumproduct formula.
Say your first condition depends on numbers in Column A, the second condition on values in Column B and your sales are in Column C then the formula will be similar to the following =SUMPRODUCT(--(A1:A6=1)*--(B1:B6="a")*C1:C6) Alok "Jamie" wrote in message ... I have been trying to figure this out with no luck! I am trying to add sales from one column but it needs to meet 2 criteria - PLEASE HELP!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with sales chart | Charts and Charting in Excel | |||
| can I use a range of dates as a criteria when using sumif? | Excel Worksheet Functions | |||
| SUMIF with more than 1 criteria | Excel Worksheet Functions | |||
| Help with Commission forumlas | Excel Worksheet Functions | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Threaded Mode
