I am trying to compose an IF function to automatically move hours around a
spread sheet. There are 5-10 areas designated by 2 letter abbreviations and
the hours need to be added to those respective areas. This is what I have so
far,

=IF(E2="ex",+D2)

is there anyway to make where is says E2 to be able to read a column
section, say E2 through E10 and wherever there is the "ex" in that column it
will add to the cell the formula is in? Any help would be appreciated. Jason