| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif as array formula
Hi all,
I have a list of related accounts in column P, and the sales budgets on Sheet1. I have tried the following formula to get the total sales budget for all of the related accounts as follows: =SUMIF(Sheet1!S:S,Sales!P4:P50,Sheet1!E:E) entered as an array formula. This does not work, but I hope from this that it is clear what I was trying to do. How can this be achieved? Thanks, Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
| Application hang with array sum(sumif... formula | Excel Worksheet Functions | |||
| Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
| Modify SumIF... Array Formula | Excel Worksheet Functions | |||
| Modify SumIF... Array Formula | Excel Worksheet Functions | |||
Threaded Mode
