Excel Formula Question

[gjrc]

hi guys,

i need a bit of help with a formula and if statments.

i have a column with months and years in it so jan 07, feb 07 march 07 etc etc

so i want to use something like this:


=SUMIF(D2: D76, "=jan 07, feb 07, march 07", C2:C76)

is this right? also can i use a wild card to include anyhting that ends in 07.

one other questions, can i exclude certain months? so all all of 07 unless its mar 07?

thanks guys.

i am a bit stuck here

ta

 

[gillywibble]

What exactly are you trying to achieve?

Could you post the spreadsheet?

 

[gjrc]

i cant really its private information for a stock market float.


basically its like this:

column A has figures column B has dates

i need to read the dates in column b (in this format march 07, jan 07, feb 07 etc etc) and then extract the figures in column A.

i also want to be able to select all of the 07 dates but exclude certain months so something like "sum all column a If coloumn C = *07 but !feb 07"

does that help?

 

[whitecrook]

Sounds like you want a database system, not a spreadsheet.

Try the LOOKUP functions, Vlookup, match, index, etc. Unless you have a finite data set , and again reletively small, IF statements in Excel would be a kludge to say the least.

 

[Participant]

Try:

=IF(B1="Jan 07",A1,if(B1="Feb 07",A1,if(B1="Mar 07",A1),0)))...etc adding all the months with the same logic.

With this method you might need to format the cell as text for it to detect it, but if the cells must be in mmm yy format, use =IF(TEXT(B1,"mmm yy")="Jan 07",....).

PS - pivot tables are what you want in this scenario!!

HTH

 

[madmaxx]

Try:

PS - pivot tables are what you want in this scenario!!

HTH

Quoted for the truth - highlight your data, insert pivot table (or whatever it is prior to 2007!) and drag the headings around - months to the left, sum of the values in the body - job done!

 

[gjrc]

thanks for all your help guys, i will give your suggestions a go.

very much apppreciated!