software

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

Look at the SUMIF() function.
See HELP for details

--
Kind regards,

Niek Otten

quot;H0MELYquot; gt; wrote in message
...
gt; Greetings, I am hoping someone knows a trick for completing a LONG if
gt; statement. Here is my statement getting info from 2 fields...
gt;
gt; =(IF(B41=Direct!E8,Direct!F8,0) (IF(B41=Direct!E9, Direct!F9,0)))
gt;
gt; I actually need this function to grab figures from E9/F9 through
gt; E250/F250,
gt; maybe even more.
gt;
gt; As you can guess I don't want to manually type that out. Any suggestions
gt; on
gt; a process that might speed up the process?
gt;
gt; The purpose of this statement is to get a total dollar amount spent for a
gt; catagory.
gt;
gt; The Bxx field is a catagory, the Direct!Exx field is a compared Catagory,
gt; and the Direct!Fxx field is a dollar amount.
gt;
gt; Any assistance is greatly appreciated
gt;
gt; -John
Well, you certainly don't need to type it out each time - just copy it
down the column and the cell references will automatically adjust to
become:

=(IF(B41=Direct!E8,Direct!F8,0) (IF(B41=Direct!E9, Direct!F9,0)))
=(IF(B42=Direct!E9,Direct!F9,0) (IF(B42=Direct!E10 ,Direct!F10,0)))
=(IF(B43=Direct!E10,Direct!F10,0) (IF(B43=Direct!E 11,Direct!F11,0)))
etc

Is that what you want to happen, or do you want to compare with B41
each time? If so, make it B$41 before copying down.

To copy the formula down, click on the cell containing it, click
lt;copygt;, then click on the cell below it, hold the lt;shiftgt; key down
while pressing lt;PageDowngt; a few times until you get to row 250, then
release lt;shiftgt; and press lt;entergt;.

Hope this helps.

PeteNiek...you are BRILLIANT. Works fabulously. You just saved me LOTS and LOTS
and LOTS of time. If you were here I would buy you a Ginger Ale Thanks a
ton.

-John

quot;Niek Ottenquot; wrote:

gt; Look at the SUMIF() function.
gt; See HELP for details
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;H0MELYquot; gt; wrote in message
gt; ...
gt; gt; Greetings, I am hoping someone knows a trick for completing a LONG if
gt; gt; statement. Here is my statement getting info from 2 fields...
gt; gt;
gt; gt; =(IF(B41=Direct!E8,Direct!F8,0) (IF(B41=Direct!E9, Direct!F9,0)))
gt; gt;
gt; gt; I actually need this function to grab figures from E9/F9 through
gt; gt; E250/F250,
gt; gt; maybe even more.
gt; gt;
gt; gt; As you can guess I don't want to manually type that out. Any suggestions
gt; gt; on
gt; gt; a process that might speed up the process?
gt; gt;
gt; gt; The purpose of this statement is to get a total dollar amount spent for a
gt; gt; catagory.
gt; gt;
gt; gt; The Bxx field is a catagory, the Direct!Exx field is a compared Catagory,
gt; gt; and the Direct!Fxx field is a dollar amount.
gt; gt;
gt; gt; Any assistance is greatly appreciated
gt; gt;
gt; gt; -John
gt;
gt;
gt;