Compressing formula

[Roinsharp]

hello!

I currently have a formula that works for my needs, however it is quite "Dirty" and i wonder if its possible to compress. Why? since others are going to be working in the same work book i dont want someone accidentally or wrongfully adjusting the formula, it would become a nightmare to try and find.

What i want it to do is make individual test down a specifik column of my tabell (E.g. B1 then B2 then B3) and add a value if true, add 0 if false.

My formula is as follows: =IF($D$3="ARP";N$3;0)+IF($D$4="ARP";N$4;0)+IF($D$5="ARP";N$5;0)+....

As you can tell it will become quite messy and laboursome to manage when you get a few hundred rows.
So in short compressing a formula to do individual tests down a tabel, is there a way of doing this without macros?

//Roin

[davsth]

=sumif(d3:d5,"ARP",n3:n5)

or in your case
=sumif(d3:d5; "ARP"; n3:n5)

[Roinsharp]

Thank you! You are the hero i need but dont deserve!