Excel 2007 conundrum

[Closed]
Report
-
 Marius -
Hello,

I need to sum rangeof prices in Q6:P143, based on a selection made from a range of calender months in I6:1143. The calender months that need to be summed is determined by the month refected in cell F3.

Is there a single formula that I could use to get my result?

Many thanks

Regards

Marius de Bruin (Pretoria, South Africa)

2 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
sorry my reply was in complete

i6 TO i143 contains calendar month some more than once I presume
using advnced filter get the unique months

for each of this month in these unique months use sumproducts
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Thank you so much for your reply. I'll surely give it a try!

Kind regards
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
i6 TO i143 contains calendar month some more than once I presume
using advnced filter get the unique months

for each of this month in