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

  • Thread starter Thread starter Gory
  • Start date Start 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.
 
Depends on your data set-up. For better answers, elaborate here with some
samples, the expected results, etc
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use Sumifs with vertically and horizontally criterias 1
Summing Based on Conditions using Array 1
Return a cell reference as a result of an IF formula 1
How to use Sumifs with vertically and horizontally criterias 3
Sum of the intersect of two named ranges 5
Summing rows using formulas with variables 1
sum last 3 numbers greater that 0 in a range 0
Financial rear date ranges in a single cell 2

Back
Top