I want to sum a range F1:F1000,if range A1:A1000 ="John" and date range B1:
B1000 =current financial year date(financial year is 1stApril to 31stMarch)
Name(colA)--------Date(ColB)---------------Amount(Col F)
John---------24-Jan-09--------------------------200
Mary--------30-Jan-09---------------------------100
Lucy--------02-Mar-09---------------------------180
John-------04-Apr-09-----------------------------300
Lucy------21-Apr-09------------------------------150
John-------23-May-09----------------------------500
Lucy------25-Jun-09-----------------------------100

I need funtion to sum John's Current year total Amout value,inthis case the
total is 800

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200907/1