how to sum values which is coming in Date Range ?

[VICTOR55]

hi to experts,

here I am wondering a formula which sum the values of which is coming in particular Month.

for example :

Sheet > Procurement Material (Rev) Column E, the sum for the month of august should be appear in the next sheet > Progress Calculation in the row C26. In the same way i want to define a same formula for entire months.

THANKS & WAITING FOR VALUABLE INPUTS......

[etaf]

RFQ is in column D , not in C - column E is T/C, so should that not populate C27 cell

would this work ?

=SUMPRODUCT(--('Procurement Material List (Rev)'!D12:D209<>""),--(MONTH('Procurement Material List (Rev)'!D12:D209)=1),--(YEAR('Procurement Material List (Rev)'!D12:D209)=2014))

if you just need the month and not worried about the year , then remove the year section

and so you do not need to enter the date - you could use the header field
=SUMPRODUCT(--('Procurement Material List (Rev)'!D12:D209<>""),--(MONTH('Procurement Material List (Rev)'!D12:D209)=MONTH(C$24)),--(YEAR('Procurement Material List (Rev)'!D12:D209)=YEAR(C$24)))

see cell C26 and E26 - highlight in green