Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array
I have values from a2:a500 which contains various dates(not sorted) and
amount in b2:b500. I would like to sum, where month(a2:a500) represents my values in c2:c13(Jan,Feb ... Dec) Please advice ... TIV. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array
in D2:
=SUMPRODUCT(--(MONTH($A$2:$A$500)=MONTH(C2)),$B$2:$B$500) where C2=01/01/2007 i.e. 1st January (for any year) formatted as "mmm" C3=01/02/2007 i.e. 1st February (for any year) Copy down to C13 "Amul" wrote: I have values from a2:a500 which contains various dates(not sorted) and amount in b2:b500. I would like to sum, where month(a2:a500) represents my values in c2:c13(Jan,Feb ... Dec) Please advice ... TIV. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array
In D2:
=SUMPRODUCT(B2:B500*(TEXT(A2:A500,"mmm")=C2)) HTH Kostis Vezerides On Jul 25, 11:50 am, Amul wrote: I have values from a2:a500 which contains various dates(not sorted) and amount in b2:b500. I would like to sum, where month(a2:a500) represents my values in c2:c13(Jan,Feb ... Dec) Please advice ... TIV. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to manipulate an 2D Array into a Column Array? | Excel Discussion (Misc queries) | |||
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 |