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

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.

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

Depends on your data set-up. For better answers, elaborate here with some
samples, the expected results, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gory" wrote in message
...
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.

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

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.


On 7$B7n(B1$BF|(B, $B8aA0(B9:14, Gory wrote:
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.