need help again please
I need to create a formula to add the dollar values in the cells of one
column based on the date values in a second column being in a certain month ie October. This is the formula I came up with but it doesn't return the correct answer:=SUMIF(AU8:AU55,"=10/01/2005=<10/31/2005",AX8:AX55) Can some one show me where my error is? thanks -- D. W. Cameron |
need help again please
Try this:
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Wayne Cameron" wrote in message ... I need to create a formula to add the dollar values in the cells of one column based on the date values in a second column being in a certain month ie October. This is the formula I came up with but it doesn't return the correct answer:=SUMIF(AU8:AU55,"=10/01/2005=<10/31/2005",AX8:AX55) Can some one show me where my error is? thanks -- D. W. Cameron |
need help again please
See response to previous post.
-- HTH RP (remove nothere from the email address if mailing direct) "Anne Troy" wrote in message ... Try this: http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Wayne Cameron" wrote in message ... I need to create a formula to add the dollar values in the cells of one column based on the date values in a second column being in a certain month ie October. This is the formula I came up with but it doesn't return the correct answer:=SUMIF(AU8:AU55,"=10/01/2005=<10/31/2005",AX8:AX55) Can some one show me where my error is? thanks -- D. W. Cameron |
All times are GMT +1. The time now is 12:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com