I'm using Office 2003 with Windows XP. I have no idea how to look this up
because I don't know what to call it, but I'm told it can be done.

I'd like to tell Excel (for example) that for each row in column M that
equals 5, then take the number in that same row from column N and add those
all together and put the total on Row 85 of column Z.

I want to do that for each of more than ten different numbers in column M.

Further, I'd like to tell Excel to collect the numbers in 85 Z from all (or
specified) pages in the workbook and place them on 85 Z on a specified page.

As you can probably tell, I want to automate a budget report. This has to be
the kind of thing Excel is made to do, I just don't know what to call it to
look it up.
--
Thanks!