slamanager
Board Regular
- Joined
- Apr 20, 2007
- Messages
- 129
Hello everyone,
I want to sum values in column "C" based on if they fall between and equal to two dates, dates in "A" and a varible in "B"
Column "A" a2-a32 dates of each day in Jan 09 31 days.
Column "B" b2-b32 letters either X Y Z randomly through range some cells may have a letter.
Column "C" Dollar value
in cell D1 Startdate in cell D2 Enddate
Formula located in D3 is the sum of all values falling between the date ranges and by one of the letters X. D4 Y. D5 Z.
Ive looked at sumif and sumproduct but have got really confused especially using inputs as criterias such as the dates any help would be apperciated.
I want to sum values in column "C" based on if they fall between and equal to two dates, dates in "A" and a varible in "B"
Column "A" a2-a32 dates of each day in Jan 09 31 days.
Column "B" b2-b32 letters either X Y Z randomly through range some cells may have a letter.
Column "C" Dollar value
in cell D1 Startdate in cell D2 Enddate
Formula located in D3 is the sum of all values falling between the date ranges and by one of the letters X. D4 Y. D5 Z.
Ive looked at sumif and sumproduct but have got really confused especially using inputs as criterias such as the dates any help would be apperciated.