### Similar Threads:

1.HELP WITH A COUPLE OF SIMPLE FORMULAS FOR A NEW USER

A couple of simple questions. I'd appreciate some help.
1)How do I get a UserForm to open automatically when I open a
worksheet in Excel.
2)MORE IMPORTANTLY....
Can someone supply me with a VBA formula to locate the next empty cell
(or row or column) after entering data in one row to go to the next
for input. The code in the books I am referring to just plain doesn't
work.
3) ALSO MORE IMPORTANTLY
How do I get a command button on a
UserForm
on sheet1 to automatically open a UserForm
on sheet2 to
enter new data.

2.Alternative formula to the vlookup formula?

I have data arranged like this:
a b c d
e f
assembly
Part No. price xyz1 xyz2 xyz3 TOTAL
abc1 1 3 1 xxx
abc2 2 2 1 xxx
abc3 3 1 3 xxx
xyz1 .4
xyz2 .5
xyz3 .6
Part abc1 is assembled with 3 pieces of xyz1 and 1 piece of xyz2. I would
like to have the cells under "TOTAL" give the total price of that part
including the assembly components so for part no. abc1, I want the price to
show $2.70, part no. abc2, to show $3.6 and part no. abc3 to show 5.2.
I am currently using a =sum(vlookup*c3, vlookup*d3, vlookup*e3) formula
which works great except that there are so many assembly items that I cannot
add any more functions to the cell. Is there a different forumla which would
allow me to find the total price?
If you need additional information, please let me know.
Thanks,
Victor

3.help with excel cell formatting - alternative aproach

If you leave the column of data as it is you can use a modified average
function to ignore the Zero values
=AVERAGE(IF(F5:F50<>0,F5:F50,""))
note it is array entered - Ctrl Shift Enter
a cleaner result IMHO
RES
>In F5 i have the formula SUM(D5*E5) the cell is formatted for currency.
When
>i drag my formula it creates in every cell $0.00 this is affecting my
>average at the bottom. How do i keep the formula but loose the $0.00?
>Thank you for your help!

4.Alternative program to Excel for array formulas

We're using a quite powerful machine: quad core extreme CPU, 4gb of Ram, XP
Pro.
However, we're dealing with array formulas which refer to a worsheet of
205,000 rows * 23 columns (ever-increasing).
Excel doesn't operate properly and on manual calculation, it shows the
message:
"Excel ran out of resources".
Is there another way to calculate such large an amount of information?
Another program that is?

5.I need alternative formula for SUMIFS in Excel 2003

I am using the SUMIFS formula in Excel 2007, but Excel 2003 doesn't
recognize this and I need to send the file to people using Excel 2003. I
tried to use SUMIF, but I have 3 criteria to search for.
Does anybody know of a similar formula that works for Excel 2003?
Thanks!

6. Couple of Questions Need Help Please.....

7. Help ! a couple of newbie questions

8. NEW USER WOULD LIKE HELP WITH A COUPLE OF PROBLEMS