Previous Topic Next Topic

Excel 2007 conundrum

Closed
Marius - Nov 19, 2011 at 03:07 AM
 Marius - Nov 19, 2011 at 07:47 AM
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)
Related:

2 responses

Answer 1 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 19, 2011 at 07:00 AM
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
Marius
Nov 19, 2011 at 07:47 AM
Thank you so much for your reply. I'll surely give it a try!

Kind regards
0
Answer 2 / 2
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 19, 2011 at 06:58 AM
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
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses