Hi!

See if this is what you had in mind:

=SUMIF(E2:E10,"ex",D2:D10)

It will sum the values in D2:D10 if the corresponding cell in E2:E10 equals
"ex".

Biff

"Jason" wrote in message
...
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