sumproduct and dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you include dates ranges in a sumproduct formula and what's the
format. eg: Column A has many dates in the format 08/11/04. I want to sum the
values in column B where the dates in A are in the range 01/01/04 to 31/12/04.
Many thanks
Peter
London, UK
 
I usually try to put the date for selection in a cell and use the cell
reference in the formula.
 
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

macro help 1
Excel Formula Help! 2
Date Axis 5
COUNT BETWEEN A SPECIFIC DATE RANGE 4
Fals Result in IF Formula 1
Find within Date Range 4
Count specific days in between dates 2
Count Dates between Dates exclude Text 3

Back
Top