Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Discontinuous Ranges in Formulas

Status
Not open for further replies.
daidohbendigo

daidohbendigo

Instructor
Jun 15, 2005
6
AU
I'm trying to use DCount using a discontinuous range to define the criteria. I've got about 80 varations on the criteria to work with hence the use of discontinuous ranges.

eg =DCOUNT(D12:F34,F12,discrange)
where discrange=Sheet6!$J$5:$J$6,Sheet6!$L$5:$L$6

Any suggestions?

Cheers

D
 
Status
Not open for further replies.

Similar threads

Damnitalldaddy
  • Locked
  • Question
excel formulas
Replies
1
Views
82
mintjulep
M
Cpreston
  • Locked
  • Question
Trim Multiple items in one column
Replies
2
Views
165
Andrzejek
Andrzejek
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
172
Andyri
Andyri
grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
236
combo
combo
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
479
combo
combo

Part and Inventory Search

Sponsor

Back
Top