Dates, lookups, and sums

  • Thread starter Thread starter FJDx
  • Start date Start date
F

FJDx

I have an Excel spreadsheet as follows:

Column A Dates in dd/mm/yy format
Column B Additional data (text)
Column C Group of figures (a)
Column D Additional data (text)
Column E Group of figures (b)

In another spreadsheet I have:

Row 1 Months going horizontally in mmm-yy format from Feb-04 to Jan-05
Row 2 Sum of figures

I would like the sum of figures to be calculated as Group of figures (a)
and (b) depending on what the corresponding date is.

I thought this would be similar to a lookup table. However, I need to be
able to add the sum of the two figures, and I need to look up the date
based on a month format, rather than individual days.
 
millsy > said:
Have a look at Pivot Tables, they seem to be what you need.
Click to expand...

Thanks but I had to do it for a number of columns. I managed to create this
array which works:
=SUM((MONTH(X!$B$4:$B$368)=MONTH(B$1))*X!$L$4:$L$368)+SUM((MONTH(X!$B$4:$B$
368)=MONTH(B$1))*X!$O$4:$O$368)

(where B4 was the month along the top)
 
Back
Top