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