M
Mhz
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.
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.