Calculating File Conditionally
There is an Excel file that teaches how to perform the Calculating File Conditionally operation.
Excel Template for Calculating File Conditionally
This workbook demonstrates calculating file conditionally using VBA macros on a 1-row data layout.
Hope it is useful.