Adding matching items in an array

[rocketman70443]

I have a huge table of figures, which I have sorted by date, and added a column that contains the month. The other columns have data regarding costs, items ordered, profit, etc.

Is there a lookup function that will let me add up all the figures that fall within the same month? To make it simple, column A contains the months, and the figures are in columns B - F

Thanks!!

 

[T. Valko]

I have a huge table of figures, which I have sorted by date, and added a column that contains the month. The other columns have data regarding costs, items ordered, profit, etc.

Is there a lookup function that will let me add up all the figures that fall within the same month? To make it simple, column A contains the months, and the figures are in columns B - F

Thanks!!

Are the months in column A dates or the month names as TEXT strings?

Jan as a TEXT entry

Or

1/1/2011 formatted to display as Jan

 

[rocketman70443]

Are the months in column A dates or the month names as TEXT strings?

Jan as a TEXT entry

Or

1/1/2011 formatted to display as Jan

jan as a text entry.

But I can convert it to the date formatted to display as jan if it'd be easier.

 

[T. Valko]

jan as a text entry.

But I can convert it to the date formatted to display as jan if it'd be easier.

It's easier if they're text entries.

Try this...

=SUMPRODUCT((A2:A10="Jan")*B2:F10)

Adjust the ranges to suit.