Greetings, I am hoping someone knows a trick for completing a LONG if
statement. Here is my statement getting info from 2 fields...

=(IF(B41=Direct!E8,Direct!F8,0)+(IF(B41=Direct!E9, Direct!F9,0)))

I actually need this function to grab figures from E9/F9 through E250/F250,
maybe even more.

As you can guess I don't want to manually type that out. Any suggestions on
a process that might speed up the process?

The purpose of this statement is to get a total dollar amount spent for a
catagory.

The Bxx field is a catagory, the Direct!Exx field is a compared Catagory,
and the Direct!Fxx field is a dollar amount.

Any assistance is greatly appreciated

-John