| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with combining 2 formulas
I would like to combine the following 2 formulas into 1 formula, yet I can't
seem to find the correct way to do it, if it is possible. =SUMIF(Invoices!$J:$J,"="&(TEXT(E1,"mmmmmmmmm-yyyy")),Invoices!F2:F2000) =SUMIF(Invoices!A2:A2000,"="&(TEXT(A21,"00000000") ),Invoices!F2:F2000) In short I want this cell to check a list of invoices and display everything by month and by account code. I would have to look at column A for the account code and column J for the date. In the master sheet I want an overview per month per account. I would appreciate any help. I would appreciate any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining formulas | Excel Discussion (Misc queries) | |||
| Combining 2 Formulas | Excel Discussion (Misc queries) | |||
| Combining Two Formulas to One | Excel Discussion (Misc queries) | |||
| Combining formulas | Excel Discussion (Misc queries) | |||
| Combining two formulas | Excel Worksheet Functions | |||
Threaded Mode
