I need to know if you can use if then or IFSUM, or IFSUMs to fix my proble.

[oparfait]

So I'm working on a form for my church.

Lets say I have in cell A3(Date) B3( Description of card transactions) C3(Amount) D3(Expense Type) E3(Merchant) F3(totals)
Those are my headings.

In cells D4:D50 I have a drop down list that show 13 Different drop downs. So if D4 has Hotel then corresponding amount will be in C4 (50.00) And lets say that D5 says Misc. and C5 has 75.00. Well over in F column I have all the expenses separated out. I want to have the total for each type in the F column. All the Hotel fees with at total... all the misc. items and a total,... all the fuel expenses...etc. Currently we have like 19 columns and I'm just trying to consolidate since I have a the drop down menu now.

Thanks in advance for your help.

[hemesh]

One way is to use pivot tables and other is to use formula.

for pivot table select A1 to D50 go to insert tab select PIVOT Table and hit enter then drag down the expense type in Row field and amount in the Values column. Click the Amount once and set the field settings to the sum.

After Completion of all entries go to analyze tab and Click refresh.

in g4 copy paste below=IF(F4="","",SUMIF($D$4:$D$50,F4,$C$4:$C$50)) then drag down

Find attached !

[FDibbins]

Try this, copied down in G...
=SUMIF($D$4:$D$30,$F4,$C$4:$C$30)

To make the copy easier (if you want to keep the spaces between each type) use this...
=IF(F4="","",SUMIF($D$4:$D$30,$F4,$C$4:$C$30))