# 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!

## 2 thoughts on “Criteria Range in Excel”

1. Karim says:

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. Karim says:

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.