Excel 2007 conundrum
Closed
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)
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:
- Excel 2007 conundrum
- Save as pdf office 2007 - Download - Other
- Excel mod apk for pc - Download - Spreadsheets
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 19, 2011 at 07:00 AM
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
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
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 19, 2011 at 06:58 AM
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
using advnced filter get the unique months
for each of this month in
Nov 19, 2011 at 07:47 AM
Kind regards