Sum data if dates in a column are w/in a specific range
I suggest you use C1 to put the date you are interested in, and then
in D1 you can have ths formula:
=SUMIF(A:A,C1,B:B)
This way your data can be as long as you like in columns A and B.
Hope this helps.
Pete
On Aug 13, 8:06*pm, lexmarcos
wrote:
I want to sum B1, with date *(constant e.g. DATEVALUE ("1/1/09"), no start
and end) IN A1. Any advice is appreciated.
AB
1 1/1/09 10
2 1/2/09 20
3 1/1/09 10
4 1/3/09 15
5
If i can find a way to sum and return values *in A5 to equal 20 (1/1/09 is
10 + 10)
Thanks.
"Jacob Skaria" wrote:
With the start and end dates in C1 and D1 ;try the below formula
=SUMPRODUCT(--(A1:A100=C1),--(A1:A100<=D1),M1:M100)
If this post helps click Yes
---------------
Jacob Skaria
"Dhardy" wrote:
I am trying to have Excel sum data in column “M” if data in column “A” is a
certain date range. Any tips/advice?- Hide quoted text -
- Show quoted text -
|