| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
using sumproduct in a range of text fields?
Hi, I have a question using sumproduct identifying a range of text in
multiple columns and calculating their values in another column. How do you use the formula- =SUMPRODUCT(('[2004 GL download master.xls]2004 GL '!$C$2:$C$189="'720'")*('[2004 GL download master.xls]2004 GL '!$D$2:$D$189="'50'")*'[2004 GL download master.xls]2004 GL '!G$2:G$189)+SUMPRODUCT(('[2004 GL download master.xls]2004 GL '!$C$2:$C$189="'725'")*('[2004 GL download master.xls]2004 GL '!$D$2:$D$189="'00'")*'[2004 GL download master.xls]2004 GL '!G$2:G$189) without typing all of the text values and using ranges? Thanks. |
|
#2
|
|||
|
|||
|
Hi
So you want for example replace ="'720'" with a range/cell reference?. Why not simüply replace it. e.g. ....=A2 "Basil" wrote: Hi, I have a question using sumproduct identifying a range of text in multiple columns and calculating their values in another column. How do you use the formula- =SUMPRODUCT(('[2004 GL download master.xls]2004 GL '!$C$2:$C$189="'720'")*('[2004 GL download master.xls]2004 GL '!$D$2:$D$189="'50'")*'[2004 GL download master.xls]2004 GL '!G$2:G$189)+SUMPRODUCT(('[2004 GL download master.xls]2004 GL '!$C$2:$C$189="'725'")*('[2004 GL download master.xls]2004 GL '!$D$2:$D$189="'00'")*'[2004 GL download master.xls]2004 GL '!G$2:G$189) without typing all of the text values and using ranges? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Excel,Auto fit - does work for large text fields | Excel Discussion (Misc queries) | |||
| Counting a range of fields with an "X" | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
