How can I sum a range using two parameters (eg location & date)

G

Gory

I am trying to sum a range of cells based on the location (listed vertically)
the item was used and the date (listed Horizontally) the item was used.
 
M

Max

Depends on your data set-up. For better answers, elaborate here with some
samples, the expected results, etc
 
P

pallaver

I may be a beginner, but I think I can field this question, or at
least get you going in the right direction.

It is possible to list a range in the form of cells:

Your Variables
Columns: DateUsed = 1
Rows: Location = 3

Sheets("Sheet1").Range(Cells(Location, DateUsed), Cells(Location + 7,
DateUsed + 2).Select

This will select the equivalent range of A3:C10

Hopefully that helps or gets your started.
 
Top