Excel formulas: Table formula referencing second table
$10-30 USD
V teku
Objavljeno pred približno 9 leti
$10-30 USD
Plačilo ob dostavi
See attached spreadsheet.
1. I want table column K to return the total value of each project column with "w" using the ProjectDetails table in the second worksheet.
2. I would like to select the range of projects, which each formula would work from. I set C2 and D2 as dropdown lists of the project headers. I set C3 to generate the table range. I don’t know how to reference C3 in my formulas to be considered a table range.