Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sums of range within sumproduct
It's a bit complicated. I have the following function:
=SUMPRODUCT((INDIRECT(B1)=1)*(INDIRECT($A$1)=2)*C1 ) I'd like to calculate a sum of the SUMPRODUCT(...) while varying B1 and C1 together (B1 references the name of a range, C1 references a number), and then apply the same formula to a new cell that replaces the named range $A$1 without having to retype everything. For example: =SUMPRODUCT((INDIRECT(B1)=1)*(INDIRECT(A1)=2)*C1)+ SUMPRODUCT((INDIRECT(B2)=1)*(INDIRECT(A1)=2)*C2)+S UMPRODUCT((INDIRECT(B3)=1)*(INDIRECT(A1)=2)*C3)+SU MPRODUCT((INDIRECT(B4)=1)*(INDIRECT(A1)=2)*C4) And then that sum repeated for A1-A4. But without having to retype everything. I would appreciate any help you have. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a value by adding certain sums in a range? | Excel Discussion (Misc queries) | |||
Sums; Automating range changes in non-neighbouring cells | Excel Discussion (Misc queries) | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Sumproduct with #N/A in range | Excel Worksheet Functions | |||
Using if or sum if to change range of sums | Excel Discussion (Misc queries) |