Need help with IF statement and adding up values from an Excel spreadsheet

Hi everyone,
I need help with a formula that I couldn't figure out on my own, so I registered here today to ask for your help!

I have a spreadsheet where in one of the columns there's a heading "Net Income:". The actual net income is right below, in the same column, but next row. For example, the text "Net Income:" is in F5, and the actual number is in F6.
The spreadsheet is logically divided into ~50 objects, so there are 50 "Net Income" values.

How do I do the following:
Go through the "F" column, and if the text is "Net Income:", take the value right below (again, value is in the same column, row + 1) and display the total (all 50 added up) on top, or do other operations on them such as AVERAGE, etc.

Note: If someone reading this thinks it's easier to hardcode (i.e. just manually sum up all the values I need), I've thought that too, but the problem is -- new objects are added every day, so I would have to constantly update manually... so this is not a good idea. My job is to automate this and not hardcode.
Thanks!

Why do you have a header "Net income" above every object? Logically, you would have a single header for a column, e.g. Name in A1, Phone number in B1, Net income in C1, etc. You can then perform whatever you want on the cells below the headers, e.g. Sum(C2:C60), as they only contain the values.
Regards, GMBIT

Originally Posted by TMShucks

It would look something like this.

=SUMIF($F$5:$J$13,$F$5,$F$6:$J$15)

But it might need adjustment to reflect the ranges you actually have.


Regards, TMS

Hi, thanks for your help, but this is something different...
Maybe this is not possible in Excel?

Basically, I need to go through a column, range is F4:F1000 and if the text is "Net Income:", take the value from the same column, ROW + 1 (right below it). There is about 50 "Net Income:" tags right now, but it keeps increasing, in a couple of months it will be 100 "records".
It's an old company that hasn't gotten around to using a database for this, they use Excel for everything and this is the format I have to work with. Thank you.

Hi and thank you everyone for the help!
The only way I was able to get this to work is by doing what Fotis suggested and making a hidden field with the word "total" in an unused column, so basically the formula that's hidden looks like this:
=IF(AND(F13="Net Income",ISNUMBER(F14)),F14,0)
Then, the formula in the summary just sums up everything in that column.
So thank you very much for that solution!

The problem with this is that I get 20-50 of these records per week, so I have to update the new records manually. The people that add those records will not create this hidden value.
Perhaps Excel is not capable of the functionality I was looking for, which is LOOP THROUGH all rows in a single column, and if the words "Net Income" are found, get the value from the next row, same column.

I have told the client that they need to implement a database, but for now, this is the way they're doing it.

Hi MikeSeattle

Does your column include other numerical values which you want ignored or does it just contain the labels 'Net Income' and the numerical values you want to include?

If it only includes the labels and the desired values, just SUM the whole column. Excel ignores the text and just performs the mathematical operation on the numerical values.

I'm afraid I have Excel 2010 and you have 2003 so this may not work on your version. All of the other arithmetic operations work too.