If then statement?

[k_a_r_l]

Hi All

I have a worksheet that is effectively a personal budget.

In line with the expenses I have a Drop Down list that allows the user to select what month the expense will be occurred (or alternatively if it is occuring every month.)

I am trying to get this data then flowing through to another spreadsheet in the same book that is a monthly budget - so that the expenses description and also the amount flows through the corresponding month.

I am some what novice at this - please excuse my ignorance - but am assuming this is some sort of nested "If/Then" sceanario... ie IF expense equals October - Expense and description appears in October on following pages.

Help Greatly appreciated

Thanks

Karl

[k_a_r_l]

Ok, so I am half way there using a SumIf Statement.

The only issue is that I am trying to incorporate a "or" statement into this so that it will sum if it occurs specifically within that month, or in the instance that it is "each Month" it will also include.

Any pointers on SUMIF using Or statements?

[k_a_r_l]

Sorted

=SUMIFS('Quick Budget'!F13,'Quick Budget'!J13,"June")+SUMIFS('Quick Budget'!F13,'Quick Budget'!J13,"Each Month")

[foxguy]

Hi karl;

Sorted

=SUMIFS('Quick Budget'!F13,'Quick Budget'!J13,"June")+SUMIFS('Quick Budget'!F13,'Quick Budget'!J13,"Each Month")

Are you asking if this is right? Or are you saying that you figured it out and this is the answer?