Thread: date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hitesh hitesh is offline
external usenet poster
 
Posts: 70
Default date

i have data in sheet1. iam working in sheet2. in sheet 1 i used sumif formula
to sum the amount given by the customer.but some time customer gives 2 time
payment. amount is sum in sheet1,but date changes

e.g
customer given 100/- on 12/5/06
same customer given again 200/- on 18/5/06

the amont is calcullated in sheet1. but how i can calc th date