http://www.askmehelpdesk.com en Sat, 21 Nov 2009 06:54:15 GMT vBulletin 60 http://www.askmehelpdesk.com/amhd_imgs/misc/rss.jpg http://www.askmehelpdesk.com http://www.askmehelpdesk.com/spreadsheets/formula-involving-date-specifically-month-417200.html Wed, 18 Nov 2009 19:22:26 GMT I'm looking for assistance with what I consider a challenging formula. I want to create a
SUMIF (if that is the right function) formula that uses a month from a date to keep track of how much time I worked on a specific project. I have a "date" cell formated 1/23/2009 and an "update time" cell that I enter a number representing an amount of time (1.5 for one and a half hours). Then I have a 12 month cells (October Hours, Novermber Hours, etc..) that I want to tally the update time entries with the date as the criteria. Is this possible?

Thanks in advance for any assistance,

Mike ]]> Spreadsheets mike1724 http://www.askmehelpdesk.com/spreadsheets/formula-involving-date-specifically-month-417200.html http://www.askmehelpdesk.com/spreadsheets/excel-tab-linkage-417044.html Wed, 18 Nov 2009 08:42:44 GMT It's about excel tab linkage.

In a same file with a few tabs below,a master tab n a few sub-tabs. What is the way to link the master tab to the sub-tabs? In such a way that, any changes in the master tab will automatically update into the particular sub-tab in a particular cell??? reply ASAP!!! Thx... ]]> Spreadsheets gonbe_88 http://www.askmehelpdesk.com/spreadsheets/excel-tab-linkage-417044.html