| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum If using 2 criterias
Hi,
I have 2 worksheets, one sheet with the columns listed below and the other sheet summarizes the activity entered in the first tab. Column A = "Amount" Column B = "Account" Column C = "Month" What I am trying to do is: SUMIF("Month"=Cell(C3) and "Account" = Cell(B6)) then return the "Amount" based on the criteria. How would I create a formula to do just that? Please let me know if need to further explain. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I have 2 criterias within sumif function | Excel Worksheet Functions | |||
| Counting instances based on two criterias | Excel Worksheet Functions | |||
| Formula requiring two different criterias | Excel Worksheet Functions | |||
| total of certain cells using 2 criterias | Excel Worksheet Functions | |||
| Multiple Data Validation Criterias | Excel Worksheet Functions | |||
Threaded Mode
