| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM IF with Array
Hi
I want to ADD numbers using multiple conditions. Andy Mark MTD 10 YTD 20 CTD 30 Andy Mark MTD 40 YTD 50 CTD 60 Jhon Mark MTD 70 YTD 80 CTD 90 Now here i want to add numbers of D coloumn If Coloumn 'A' has 'Andy' , Coloumn 'B' has 'Mark' and Coloumn 'C' has YTD Rember A2, A3, A5, A6, B2, B3, B5 and B6 cells are blank. If I repeat Andy and Mark in each row then its very easy to sum but i dont want to do that. The formula should return the result (20 + 50) = 70 I want to add value for 'Andy' 'Mark' and 'YTD' and i dont want to repeat andy and mark's name Could you please let me know the solution. Thanks Milind |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
| Array: Counting multiple values within array | Excel Worksheet Functions | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| Goal Seek On Members of an Array within Array | Excel Worksheet Functions | |||
Threaded Mode
