Functions

Worksheet design: How to allocate costs to plants?
Hi, I'm trying to find a way to allocate administrative costs to plants. I have a worksheet set up to do it, but it's complicated and doesn't handle adding new accounts gracefully. Here's a simplified example of what I'm trying to do: Take all of the costs in the Admin department: Dept Acct ... 4 Jul 2008 01:50

Count rows after filter
I want to count how many rows are left in the worksheet after I used filter and some rows had been hidden. COUNTA give me all rows and not the one after filter. Are there any function can do that or need to use VBA? Thank you. ... 4 Jul 2008 02:51

May be a long-shot, but.....
Hello all. For the life of me, I can't get my sum functions to work with text entries. FTR, I am using Excel 2003. The purpose lays in this example... I have a column with three different alpha-codes that have been designated like this: A denotes blue textbooks B denotes brown textbooks C denotes red textbooks ... 4 Jul 2008 08:59

#value! Error
The below function returns a #value! error. I would like the below function to return "-" only if every cell in the range is empty. Help is appreciated writing this. =IF(B56:af56="","-",AVERAGE(B56:AF56)) -- Sony Luvy ... 5 Jul 2008 00:19

Copy from another sheet but spreading the data out down the co
Hi RagDyer Thanks for the formula I have put this in my sheet and with a few modifications is working well. Essentially I now need a formula for converting back. Say my data occurs every 4th row in column A ie A3, A7, A11 etc... I would like to put this into sheet 3 but so that the results are one after the ... 4 Jul 2008 03:52

Data Validation lists update orginal cell with list update
Hello, I need some help. I am using a data validation list to help people populate the destination cell with the required value. The data validaton list is populated using a formula that references to a table on another sheet. Users are expected to change the values on this table to their suitable name. F... 11 Jul 2008 03:48

Restricting cell data amount
G'day all Can anyone help with the following. I need to restrict all cells in Column K, so that a maximum of 40 characters can only be displayed. I would like to incorporate it into my existing code so that it will trim any cells in that column automatically if they exceed the limit. TIA Mark. ... 4 Jul 2008 02:51

drop info auto from sheet 1 to 2
how do i get info to automaticly fall onto sheet 2 when working in sheet 1 ... 4 Jul 2008 01:50

Sum of visible cells with multiple filters - Office 2007
I'm trying to make a commission schedule with basic setup like as follows: A B C D E 1 Date Client Type Pay Tax 2 12 Jun Smith A 100 10 3 19 Jun Jones B 240 24 4 21 Jun Frost A 180 18 5 23 Jul Kris C... 3 Jul 2008 22:47

Simplify Formula
Hello, can someone help me simplify this formula? =IF(B2="Baby Boomer",B3)+IF(D2="Baby Boomer",D3,0)+IF(F2="Baby Boomer",F3,0)+IF(H2="Baby Boomer",H3)+IF(J2="Baby Boomer",J3,0)+IF(L2="Baby Boomer",L3,0)+IF(N2="Baby Boomer",N3)+IF(P2="Baby Boomer",P3,0)+IF(R2="Baby Boomer",R3,0)+IF(T2="Baby Boomer",T3)+IF(V2="B... 3 Jul 2008 21:45