Hi
i have list of bonds with their maturity dates and values. I need the sum of bonds maturing for 2012, 2013, 2015, 2020
what is the correct formula?
i tried
SUMIF(F5:F59,"1/jan/2012<31/dec/2012",O5:O59)
but is doesnt work
pls help
Hi
i have list of bonds with their maturity dates and values. I need the sum of bonds maturing for 2012, 2013, 2015, 2020
what is the correct formula?
i tried
SUMIF(F5:F59,"1/jan/2012<31/dec/2012",O5:O59)
but is doesnt work
pls help
can you post your workbook?
Hello df180
Welcome to the Forum.
Can you try this one.
Experiment on it.Please Login or Register to view this content.
HTH.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks