| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using sumproduct function to count cell values on a remote workbook
Hey guys, thanks in advance for help..
I have a function that looks like this right now... =SUMPRODUCT(--( 'http://someurl.com/[VARIABLE FILE NAME.xlsx]SheetName'!$F$1:$F$65000="P")) It calls out to a column in another sheet by URL and counts the number of times a certain value is displayed in column F. Right now it only works when I manually type in the URL. What I want to do is somehow update VARIABLE FILE NAME to be the value in a specific cell. Any idea how I could replace Variable File Name with a cell value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using SUMPRODUCT to count values in separate columns | Excel Worksheet Functions | |||
| Count If 2 Diff Values Appear on Several Worksheets w/in Workbook | Excel Worksheet Functions | |||
| Function to count unique values? | Excel Worksheet Functions | |||
| Sumif function with remote cell references | Excel Worksheet Functions | |||
| REMOTE CELL FUNCTION | Excel Worksheet Functions | |||
Threaded Mode
