Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've tried SUMIF, and SUMPRODUCT. . .Trying to total values that
occurred within a given year: We have a column of historical costs, and a corresponding item purchase date. The historical costs to total are in a range such as V5:V2050. (Some cells may be blank) The dates those values were purchased are in a range such as Z5:Z2050 (formatted as Jan-00 or Jun-03, etc) In a group of cells, 1 each for the years 1999 thru 2004 I'd like to have a total of dollars that were spent for each year, with the values that were summed located in column V as noted above. For example: Col:V Col:Z 55.62 Jan-99 12.50 Feb-04 104.88 Sept-04 0.12 Aug-03 RESULTS A summary cell for each year would show: That in 1999 purchases were 55.62 In 2003, purchases were 0.12. In 2004 purchases were 117.38 Thanks in advance for any ideas to make this happen. Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
linked values in a chart | Charts and Charting in Excel |