I have a Sum function at the end of each row. When I enter the new monthly
number, it doesn't recalculate. F9 has no effect. If I change Sum (B1:m1)

software 發表在 痞客邦 留言(0) 人氣()


Need formula to figure amount of sales per person in a given month.

software 發表在 痞客邦 留言(0) 人氣()

How can we attact a customized tool on the menu bar with a drop down feature,
and also be able to email the link (which once clicked would automatically

software 發表在 痞客邦 留言(0) 人氣()

Hi,

software 發表在 痞客邦 留言(0) 人氣()

I have some fairly complicated excel files with let say 100 worksheets
in them.

software 發表在 痞客邦 留言(0) 人氣()

How can we attact a customized tool on the menu bar with a drop down feature,
and also be able to email the link (which once clicked would automatically

software 發表在 痞客邦 留言(0) 人氣()

=IF(A1=1,IF(OR(COUNTIF(A1:AS2,1)=2,SUM(COUNTIF(A6: E7,1),COUNTIF(A11:E12,1),COUNTIF(A16:E:17,1),COUNT IF(A21:E22,1),COUNTIF(A26:E27,1)COUNTIF(A31:E32,1) ,COUNTIF(A36:E37,1),COUNTIF(A41:E42,1)=1),1,quot;quot;),quot;quot; ))

software 發表在 痞客邦 留言(0) 人氣()

I'm a bit new to excel VBA and wondered if it is possible to pass a UDF
reference as an argument to a UDF as in:

software 發表在 痞客邦 留言(0) 人氣()

how to convert xlw. file to xls. file?
thanks

software 發表在 痞客邦 留言(0) 人氣()

I use the INTRATE formula in an old spreadsheet. What function replaces this
as I get a #NAME error now?

software 發表在 痞客邦 留言(0) 人氣()