# Excel help **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [October 8, 2008, 6:40am UTC](https://forums.speedlife.net/t/excel-help/56111 "2008-10-08T06:40:22Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![slipstreamxk1](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@slipstreamxk1](https://forums.speedlife.net/u/slipstreamxk1)\ **Post date:** [October 8, 2008, 6:40am UTC](https://forums.speedlife.net/t/excel-help/56111/1 "2008-10-08T06:40:22Z")
wondering if there is an easier way of counting the total number of something by month. I.E. like total checking accounts opened by each associate per month. I was using the Dcount function but im trying to streamline this database and there is way to much code to alter or add when someone new comes in or when the years change over. I was thinking a Pivot table maybe but how can i group it by month in that case? any other ideas? Thanks. ---
**Author:** ![slipstreamxk1](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@slipstreamxk1](https://forums.speedlife.net/u/slipstreamxk1)\ **Post date:** [October 8, 2008, 7:14am UTC](https://forums.speedlife.net/t/excel-help/56111/2 "2008-10-08T07:14:51Z")
nm figured it out. Pivot table FTW. ---
**Author:** ![zwarbyt](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/zwarbyt/32/7623_2.png) [@zwarbyt](https://forums.speedlife.net/u/zwarbyt)\ **Post date:** [October 8, 2008, 7:20am UTC](https://forums.speedlife.net/t/excel-help/56111/3 "2008-10-08T07:20:54Z")
sumproduct ---
**Author:** ![slipstreamxk1](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@slipstreamxk1](https://forums.speedlife.net/u/slipstreamxk1)\ **Post date:** [October 8, 2008, 7:52am UTC](https://forums.speedlife.net/t/excel-help/56111/4 "2008-10-08T07:52:11Z")
lol ok new issue now with pivot tables… I’m Trying to leave it open for when new data comes in. which is daily. to auto add into the table so… for the data range im putting in for example a1:f65332. When i do this it wont allow me to group the data by month. any suggestions? ---
**Author:** ![slipstreamxk1](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@slipstreamxk1](https://forums.speedlife.net/u/slipstreamxk1)\ **Post date:** [October 8, 2008, 7:56am UTC](https://forums.speedlife.net/t/excel-help/56111/5 "2008-10-08T07:56:35Z")
sumproduct would be for adding then multply fields not totaling the amount of a product by month. Thanks for the suggestion though! ---
**Author:** ![duck](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/duck/32/7183_2.png) [@duck](https://forums.speedlife.net/u/duck)\ **Post date:** [October 8, 2008, 8:05am UTC](https://forums.speedlife.net/t/excel-help/56111/6 "2008-10-08T08:05:10Z")
advanced filter if you want to keep all the detail, pivot table if you only want a summary ---
**Author:** ![BigRon](https://avatars.discourse-cdn.com/v4/letter/b/58956e/32.png) [@BigRon](https://forums.speedlife.net/u/BigRon)\ **Post date:** [October 8, 2008, 9:36am UTC](https://forums.speedlife.net/t/excel-help/56111/7 "2008-10-08T09:36:51Z")
countif or sumif? Without seeing the data it is hard to understand what you are trying to do. ---
**Author:** ![tpgsr](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/tpgsr/32/7374_2.png) [@tpgsr](https://forums.speedlife.net/u/tpgsr)\ **Post date:** [October 8, 2008, 9:39am UTC](https://forums.speedlife.net/t/excel-help/56111/8 "2008-10-08T09:39:30Z")
VBA ---
**Author:** ![slipstreamxk1](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@slipstreamxk1](https://forums.speedlife.net/u/slipstreamxk1)\ **Post date:** [October 8, 2008, 9:42am UTC](https://forums.speedlife.net/t/excel-help/56111/9 "2008-10-08T09:42:18Z")
got it working… Pivot tables apparently dont like blank feilds. I just threw in a bunch of dates and 0’s to make it work. Now to work out the security details heh. I’m sure that will make more questions pop up. ---
**Author:** ![tpgsr](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/tpgsr/32/7374_2.png) [@tpgsr](https://forums.speedlife.net/u/tpgsr)\ **Post date:** [October 8, 2008, 9:43am UTC](https://forums.speedlife.net/t/excel-help/56111/10 "2008-10-08T09:43:24Z")
Excel in general doesn’t like blank fields. ---
**Author:** ![slipstreamxk1](https://avatars.discourse-cdn.com/v4/letter/s/6bbea6/32.png) [@slipstreamxk1](https://forums.speedlife.net/u/slipstreamxk1)\ **Post date:** [October 8, 2008, 12:35pm UTC](https://forums.speedlife.net/t/excel-help/56111/11 "2008-10-08T12:35:16Z")
sigh… ok anyone ever get this before when updating imported info from an access db? I have a Work information file created with user permissions set. I’ll plug in my login details and then it asks me for DB password. There isnt one set and it wont allow me in at all.