How to use INDIRECT with a SUMIF formula for a date range

microsoft-excel worksheet-function microsoft-excel-2007 microsoft-excel-2010

Try this out and see if it works:

=SUMIFS(INDIRECT("'"&A1&"'!5:5"),INDIRECT("'"&A1&"'!2:2"),">="&B1,INDIRECT("'"&A1&"'!2:2"),"<="&C1)

Related

How is the Tool Menu next to the cursor called? Can it be edited?
Same AllowedIPs for multiple peers with wireguard
What limits the size (GB) of RAM module I can install in a RAM slot? [duplicate]
Unable to change from UEFI to Legacy Mode
Batch script to append record to csv files
Can I re-partition my C: drive during (for example) factory reset to give it a bigger space allocation?
Trying to use miredo, missing libtun6.so.0
How to enable CORS on server-side code in java
Clone object within object [duplicate]
JDBCConnectionException "Unable to acquire JDBC Connection" with spring boot
Access to image at '' from origin 'null' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource [duplicate]
Can't debug Golang with breakpoints in VSCode