sumif between or product

  • Thread starter Thread starter mathewheys
  • Start date Start date
M

mathewheys

Hi All

I am trying to sum data that is between two dates cel D2 contains the
lowest dateand cell D3 contains the highest date

Column A contains All the dates
Column B contains all the Number data

someone I work with said that it could be Product

EG
A / B / C / D
1 10/2/05 125 11/2/05
2 11/2/05 150 14/2/05
3 12/2/05 156
4 13/2/05 135
5 14/2/05 142
6 15/2/05 129

The answer would be 583


Thanks
 
probably one of the numbers must have remained as text when I copy-pasted
the figures in my workbook. And I didn't bother to check-up the difference.

Mangesh
 
Back
Top