Excel Magic Trick 1428: VLOOKUP, COUNTIFS & IF Helper Column to Calculate Asset Current Value

See how to create a formula that will calculate the Current value of an investment for each row of the table. The table has the yearly Growth Rate and Asset Name. See how to use COUNTIFS, VLOOKUP and The IF Function to correctly calculate current asset value for each row.

[christianneuberger]

Hi Mike,

without Helper-Column: for example the results in Table H4 ...H8:
H4:
Growth Rate], ))}

[UnknownChannel]

Issue when using COUNTIFS on closed workbooks it doesn't work. Also I have heard to utilize =SUMPRODUCT, but with the criteria I need for the countifs sumproduct doesn work, seems wayyyy over complicated. I am trying to count date ranges . Weekly, count how many dates per week, then another critiera such as if the patient was actually scheduled or not (2rd criteria) this excludes our canceled patients. So simple right? NOT! HAve to be able to count when workbook is closed.

[Al-Ahdal]

Excellent as always.... Could you please advise some great stuff in "MS ACCESS"? or when you are planning to start MS ACCESS videos, though I have seen some real good videos of yours on MS ACCESS, but need much more on that. Kindly advise.

[jurdegreeuw]

Since you working with currency, do you need ro round to the penny each year? What would be the difference in dollars after 25 years or rows?
Grz. from the netherlands.
--
Jurriaan

[Zocoloni]

You can simplify your formula to NOT use COUNTIFS! =IF(B4=B3, TRUE, FALSE) will give you the same array of TRUE and FALSE.