Problem Calculating Various Month Totals ??
 

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...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=570294

Problem Calculating Various Month Totals ??
 

I tried your formula and it worked for me, I got a total of 65. What
exactly is going wrong on your end?

Problem Calculating Various Month Totals ??
 

If cell was formated mmmm dd, yyyy

the formuale wouldn't work

Steve


On Thu, 10 Aug 2006 14:26:30 +0100, Mark wrote:



I tried your formula and it worked for me, I got a total of 65. What
exactly is going wrong on your end?

Problem Calculating Various Month Totals ??
 

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...o&userid=35980
View this thread: http://www.excelforum.com/showthread...hreadid=570294