Excel dsum, daverage, forecast, edate, dcount formula

DSUM() function

Here you will also get the value of the sum but you will use condition. You will get the sum, according to the condition.

formula: =DSUM(Table, field, Condition)

In the formula, field means that column name which values you want to see as a result. Select only the column name cell not the whole column.

Suppose you have a Brand, Version, Generation, and price column in the table. Now according to the Brand, Version, Generation you want to find price.

At first copy, the column names of the table and paste it anywhere on the sheet. Then below the Brand, Version, Generation write Brand, Version, Generation value, and below price write DMAX formula.

Here the field is the price column and the condition is Brand, Version, Generation column value.

DAVERAGE() function

Here you also get the average value but here you will use condition. You will get the average value according to the condition.

formula: =DAVERAGE(Table, field, Condition)

In the formula, field means that column name which value you want to see as a result. Here we have to select only the column name cell.

Suppose you have a Brand, Version, Generation, and price column in the table.Now according to the Brand, Version, Generation you have to find price.

At first copy, the column names of the table and paste it anywhere on the sheet. Then below the Brand, Version, Generation write Brand, Version, Generation value, and below price write DMAX formula.

Here the field is the price column and the condition is Brand, Version, Generation column value.

DCOUNT() function

Here you also get count value but here you will use condition. You will get the average value according to the condition.

formula: =DCOUNT(Table, field, Condition)

In the formula, field means that column name which value you want to see as a result. Here we have to select only the column name cell.

Suppose you have a Brand, Version, Generation, and price column in the table.Now according to the Brand, Version, Generation you have to find price.

At first copy, the column names of the table and paste it anywhere on the sheet. Then below the Brand, Version, Generation write Brand, Version,Generation value, and below price write DCOUNT formula.

Here the field is the price column and the condition is Brand, Version, Generation column value.

FORECAST function

This function predicts future value depending on the previous value. Suppose you have the year 2020 12 months earnings.Now if you want to know that according to 2020 12 months earning, what will be the earning of 2021 12 months. To do this use FORECAST function.

Formula: =FORECAST(X,known_ys,know_xs)

Suppose you have the year 2020 12 months earnings. Now you want to know that according to 2020 12 months earning what will be the earning of 2021 12 months. In this case, X will be 2021 current month. First comes January. So January-2021 cell will be X. You want to find earnings depending on the 2020 month earning.known_ys means 2020 earning column. known_xs means 2020 month column.

EDATE() function

This function helps to generate the end date. Suppose you have a date of 25/2/2000. Now you want to see what will be the date after 2 months and you know that it is 25/4/2000. So EDATE function will create this date.
Formula: =EDATE(cell, gap between months)
Here cell means that cell where you wrote the current date. Suppose you want to see after two months from the current date. So here 2 will be a gap between months.