Solved Excel Drop Down Category Sum

August 3, 2015 at 09:01:32
Specs: Windows 8
Help! I am classifying a bank statement on Excel.
I created a drop down for the transaction type in Column F; Column E has the transaction amounts.

How can I create a formula to sum up the amounts per catergory?

message edited by trosi88

See More: Excel Drop Down Category Sum

Report •

August 3, 2015 at 12:34:13
✔ Best Answer
A =SUMIF() should work.

They structure is:

=SUMIF( range, criteria, [sum_range] )

so something like:



Report •
Related Solutions

Ask Question