Criteria Range in Excel

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

2 thoughts on “Criteria Range in Excel”

  1. 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

  2. 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

Leave a Reply

Your email address will not be published. Required fields are marked *