Bill Golden
asked on
Sum a range of cells using certain criteria in Excel
I want to total a range of cells given certain criteria that would identify the first cell in the range to total and XX number of cells afterwards. For instance, In the attached file I am looking to total C25 through C49. (B7 is a user defined date and B8 is the number of cells to be summed.
Enclosure
Enclosure
No Attachment
Maybe this will help
=SUM(INDIRECT(ADDRESS(11+M ATCH(B7,A1 2:A63,0),3 )&":"&ADDR ESS(11+MAT CH(B7,A12: A63,0)+B8- 1,3)))
Regards
EE2041119.xlsx
=SUM(INDIRECT(ADDRESS(11+M
Regards
EE2041119.xlsx
ASKER
Regardless of where I place your formula, it returns #N/A, except for cells A11..A14.
Obviously I have lost something in translation.
Obviously I have lost something in translation.
Without your attachement it is difficult to know what you want
ASKER
I am sorry. I thought I uploaded the spreadsheet with my original post. It is attached. Your formula appears in cell B9.
Decline-Curve-Calc.xls
Decline-Curve-Calc.xls
then pls try
=SUM(INDIRECT(ADDRESS(14+M ATCH(B7,B1 5:B87,0),3 )&":"&ADDR ESS(14+MAT CH(B7,B15: B87,0)+B8- 1,3)))
Decline-Curve-CalcV1.xls
=SUM(INDIRECT(ADDRESS(14+M
Decline-Curve-CalcV1.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent solution. Thanks.