Criteria Range

While working with database functions and advanced filter in Microsoft Excel you often notice that people get stuck with the definition of ‘criteria’ or ‘criteria range’. It’s not as if they don’t understand these words; they actually have forgotten the process. Watch the training video to get the hang of the process and you’ll never forget it – hopefully!

Further reading:

Filter by using advanced criteria

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

‘Range(“F3”).Formula = “=SUM(E3*C3)”

Range(“F3:F10000”).Formula = “=SUM(E3*C3)”

‘Range(“J3”).Formula = “=SUM(E3*G3)-M3”

Range(“J3:J10000”).Formula = “=SUM(E3*G3)-M3”

‘Range(“M3”).Formula = “=SUM(L3*C3)”

Range(“M3:M10000”).Formula = “=SUM(L3*C3)”

‘Range(“P3”).Formula = “=SUM(O3*C3)”

Range(“P3:P10000”).Formula = “=SUM(O3*C3)”

‘Range(“Q3”).Formula = “=SUM(E3-Z3)”

Range(“Q3:Q10000”).Formula = “=SUM(E3-Z3)”

‘Range(“R3”).Formula = “=SUM(G3-C3)”

Range(“R3:R10000”).Formula = “=SUM(G3-C3)”

End Sub

Dear Sir,

I am try to to set below code but there are error, hereby i am reqsting to you that can you help me up.

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

‘Range(“F3”).Formula = “=SUM(E3*C3)”

Range(“F3:F10000”).Formula = “=SUM(E3*C3)”

‘Range(“J3”).Formula = “=SUM(E3*G3)-M3”

Range(“J3:J10000”).Formula = “=SUM(E3*G3)-M3”

‘Range(“M3”).Formula = “=SUM(L3*C3)”

Range(“M3:M10000”).Formula = “=SUM(L3*C3)”

‘Range(“P3”).Formula = “=SUM(O3*C3)”

Range(“P3:P10000”).Formula = “=SUM(O3*C3)”

‘Range(“Q3”).Formula = “=SUM(E3-Z3)”

Range(“Q3:Q10000”).Formula = “=SUM(E3-Z3)”

‘Range(“R3”).Formula = “=SUM(G3-C3)”

Range(“R3:R10000”).Formula = “=SUM(G3-C3)”

End Sub

Thanks

Karim