hello,

I need a formula that will SUM values for particular Months within
column (B4:B1000)...

I am trying to use a formula that will identify the first 3 letters o
the month and then add the currency (G4:G1000) for those months only..
every formula I am attempting to use is not working..

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 varie
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 I
ADVANCE.

--
Mh
-----------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...fo&userid=3598
View this thread: http://www.excelforum.com/showthread.php?threadid=57029

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

If cell was formated mmmm dd, yyyy

the formuale wouldn't work

Steve


On Thu, 10 Aug 2006 14:26:30 +0100, Mark <(E-Mail Removed)> wrote:

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

Thanks very Much Steve, That was definately the problem....

I reformated the cells as TEXT, but now it will take me longer to inpu
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..

--
Mh
-----------------------------------------------------------------------
Mhz's Profile: http://www.excelforum.com/member.php...fo&userid=3598
View this thread: http://www.excelforum.com/showthread.php?threadid=57029