Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Variable ranges
Hi,
I seem to have become a bit lost, hoping you guys can help, I am wanting to replace a number of array formulas. Example: =SUM(IF((DUDListData!$T$2:$T$65536=DUDListData!$Y$ 1)*(DUDListData!$U$2:$U$65536=Summary!$G$2)=1,1,0) )/SUM(IF(DUDListData!$U$2:$U$65536=Summary!$G$2,1,0) ) I thought these were great idea, and they work great, but I understand I should be using the offset and indirect functions to declare the ranges. Is this correct? If so could someone give me a start to work on please. My mind has gone blank on this one as I have never used these functions before. Many thanks in advance John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Ranges for a Chart | Charts and Charting in Excel | |||
Sum Variable Ranges | Excel Worksheet Functions | |||
Variable Print Ranges | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |