Nested If statements returning a sum calculation

G

Guest

At this point I am using this formula to return a dollar amount.

=If(a4="income",e4)+if(a5="income",e5)...excel will only let me put in 25
but I need at least 50 of these statements. I am trying to create a running
balance sheet that updates my monthly budget. however, when my input passes
row 25 then nothing gets calculated.

I need a formula that will say:
if "INCOME" is chosen from a list then return the amount of the credit.
Then add all "INCoME" credits in the chart.

I tried Countif also, but it only returned how many "INCOME" are in the
column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allocate an income payment over a date range (tax years) 7
Nested IF 2
Nested IF Statements 1
Exceeding Limit on Nested IF Statements 4
"What-if" formula for either a manual entry and automated entry 3
Nested IF statements 2
Help!!! Vlookup!! 3
Returning text from nested IF and Vlookup statements 10

Top