Excel Auto Update with Formula

Dear All,

Greetings, Please Help.

Here with I have attached file of "DIESEL REPORT MANUAL ENTRY_MAY 2015". In that file having two sheets names "Summary" and "Issued".
My requirement is when I entering the Diesel Issued datas in to the Issued sheet at the same time will update automatically in the summary sheet as per the transaction date for that Diesel Issued to particular Jobs Number. Kindly get the solution with Excel suitable formula function.


Thanks & Regards
iqubalemco

Hi,

Please see the attached file, I have updated the following formula.

=SUMPRODUCT(--(ISSUED!$B$5:$B$25=Summery!$B6),--(ISSUED!$F$5:$F$25=Summery!C$4),ISSUED!$G$5:$G$25)

Dear cbtrody,

Its fine but the date not update aromatically in to the Summary sheet. I could want that date update also please.

Thanks,

Please see the attached file.