Vlookup formula

[akber.431]

hi can anyone help me in the Vlookup formula


i have one excel sheet it contains

PDC (Post dated cheque) details

A)Cheue #
B)Date
C)Amount
D) Status


i want to calculate the DUE, RECEIVED amount as per the status, cell information.



how can i do that

help me

right now i m calculating by sum formula,

 

[CharlesChuckieCharles]

=SUMIF(D:D,"Due",C:C)

"due" can be replaced by a cell reference