| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why won't ADDRESS work nested inside SUMIF?
If I do this:
=ADDRESS(4,MATCH(E37,A2:JW2,0)) I get: $L$4 If I do: =SUMIF(A3:JW3,"Units",ADDRESS(4,MATCH(E37,A2:JW2,0 )):JW4) I get an error. However if I do: =SUMIF(A3:JW3,"Units",INDIRECT(G1):JW4) I get the answer I want. However, I'd prefer to not have a helper cell. Please help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use a Reference inside a SUMIF or COUNTIF Function? | Excel Worksheet Functions | |||
| INDIRECT(ADDRESS) inside a VLOOKUP | Excel Worksheet Functions | |||
| WORKSHEET INSIDE A WORK BOOK | Excel Worksheet Functions | |||
| sumif with nested address | Excel Discussion (Misc queries) | |||
| Date Format Inside of a SUMIF Statement | Excel Worksheet Functions | |||
Threaded Mode
