| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Sum Array Formula
Thank You, That is what I was looking for....works better not to call
anything out specifically then the list can change without having to re- evaluate the formula. engoo wrote: You may modify the formula to refer to the corresponding value in Column A for each row: =SUMIF(A:A,A2,B:B) Enter this formula in Cell C2 and copy it down for all rows.. On May 24, 12:14 pm, Tom Ogilvy wrote: also look at using a pivot table report under the data menu. [quoted text clipped - 50 lines] - Show quoted text - -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| IF or Array formula excel .. help ! | Excel Worksheet Functions | |||
| array or IF formula excel help | Excel Discussion (Misc queries) | |||
| excel array formula | Excel Worksheet Functions | |||
| Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
Threaded Mode
