Problem Calculating Various Month Totals ?? Mhz <Mhz.2cbq7r_1155212708.7888[ at ]excelforum-nospam.com> 10.08.2006 12:21:01 hello, I need a formula that will SUM values for particular Months within a column (B4:B1000)... I am trying to use a formula that will identify the first 3 letters of the month and then add the currency (G4:G1000) for those months only.. every formula I am attempting to use is not working..:confused: I used this to calculate the totals for February, but it fails: =SUMIF(B4:B1000,"FEB*",G4:G1000) G4:G1000 contains the amounts for various months. The months varies through column B4:B1000.. Any help on this is Appreciated... eg. ITEM DATE AMOUNT _____ _____ ________ RAG FEBRUARY 6, 2005 $25.00 COAT JANUARY 3, 2005 $15.00 BEER FEBRUARY 10, 2005 $40.00 HAM MARCH 15, 2005 $8.00 AS EXAMPLE, I WOULD NEED THE TOTALS FOR FEBRUARY ONLY .....THANKS IN ADVANCE.. -- Mhz ------------------------------------------------------------------------ Mhz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35980 View this thread: http://www.excelforum.com/showthread.php?threadid=570294

Re: Problem Calculating Various Month Totals ?? "Mark" <twox4s[ at ]yahoo.com> 10.08.2006 13:26:30 I tried your formula and it worked for me, I got a total of 65. What exactly is going wrong on your end?

Re: Problem Calculating Various Month Totals ?? SteveW <sj_walton[ at ]nothotmail.com> 10.08.2006 14:54:50 If cell was formated mmmm dd, yyyy the formuale wouldn't work Steve On Thu, 10 Aug 2006 14:26:30 +0100, Mark <twox4s[ at ]yahoo.com> wrote: [Quoted Text] > > > I tried your formula and it worked for me, I got a total of 65. What > exactly is going wrong on your end? >

Re: Problem Calculating Various Month Totals ?? Mhz <Mhz.2cd09z_1155272405.5531[ at ]excelforum-nospam.com> 11.08.2006 04:58:15 Thanks very Much Steve, :) That was definately the problem.... I reformated the cells as TEXT, but now it will take me longer to input the dates. BUT THATS A OK! THANKS! Thanks to you also Mark... The problem on my end is described above, thanks for the input anyhow... -- Mhz ------------------------------------------------------------------------ Mhz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35980 View this thread: http://www.excelforum.com/showthread.php?threadid=570294