excel formula help

I'm trying to do something I don't know if it can be done. I want to add the number of consecutive 12's until a 0 is hit (this is my data that changes frequently). The results would give the total of the consecutive 12's. I've hit a brick wall with this. Any ideas...

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

Hello Everyone, I have an interesting problem where I have -- Table 1 with 1 row containing revenue forecast values and 20 columns (1 for each week therefore 20 weeks) and Table 2 with 6 rows & 12 columns in which the first row has 2 numbers either 4 or 5 which denotes the number of weeks...

Hello everyone, Hope you are having a great week. I am trying to figure out a way to calculate AHT (Average Handling time) for each cases irrespective of the dates. Just to summarize the table, DE stands for Data Entry. Average handling time is calculated as the total time taken to complete a...

I want to write an excel formula that can compute commission charged using simple interest rate. The fields will be: Amount Percentage Commission charged How do i write a formula that can provide answers to any field once the other two fields have been completed?

Page 1 C372)Ag Non Real Estate C374)City. D375)#loan E375)Balance C375)Ag loan. C376)Ag line Page 2 A1)Ag Non Real Estate. B1)City. C1)Product. D1)Ag loan. E1)4. F1)$480 Ag Non Real Estate. City. Ag line. 3. $350 (same layout as first record) How do I bring back the count and dollars to page...

Hi Team, Hi I am trying to create a formula to find the net chargeable amount. Lets say <colgroup><col></colgroup><tbody> A2=Chargeable weight B2= price per kilo post 15 kilos for the 1st 5 kilos C2= price per kilo after that </tbody> e.g. If the total weight is 25 kgs, I want the formula...

Hi, I am struggling a bit to get my date formulas working. In a sense it is a 2 pt question. I basically have a date of which I need to add X amount of days which may go into into the next month at times. Then if that target date after getting added x days is a weekend or holiday it needs to go...

I have two tabs in my excel sheet. Tab 1: Contains a list of all the dependencies across multiple functional area. The columns are functional area, dependency description, dependency id, plan end date, target end date. Tab 2: Contains a list of tasks with the following columns: Functional...

Hi All, I need some help with creating an excel formula. On sheet one, i want to add a value ($100) on cell D5 and a date on cell E5. Then, sheet two has all the months listed (january to december) down one column from cell A9 to A20. If the date of E5 (on sheet one) equals March, then i want...

Good afternoon all Can anybody please help me translate the formula below into Excel speak: Answer = 10 log[10^(X1/10)+10^(X2/10)+10^(X3/10)] Where X1, X2 & X3 are my data entry points. I have tried it as the following but the answer is not what I expect...

I want to prepare a mark-sheet of an examination (in excel format by putting formulas) where the students have to sit for six papers (100 marks each), each divided into two parts – theory and practical – pass-mark – 30% of full marks in theory and 30% of full mark in practical. But failure in...

I have an excel 2007 document which I created a survey with questions and yes/no answers. After creation, I was asked to add a third option -- an "N/A" response. I added the N/A to the drop down menu for response options to the questions. However, by answering "No", I have formulas set to...

i have a column containing 1 to 36 representing months(A2:A37) and i have one more cell(M1) in which i am calculating the month by taking difference between two dates. So i want a formula that match M1 with A2:A37 value and based on match i want to add the column values(B2:B37) corresponding to...

Hi there, can someone please be so kind as to help me resolve this issue. I am doing a study for my research article. I have the spreadsheet below: <colgroup><col><col><col><col><col><col><col span="2"><col><col span="2"><col><col span="2"><col><col span="2"><col span="3"><col span="7"><col...

Hello !! I tried various options and am stuck w/my limited knowledge!! its my first time here and am looking for some help. Is there a way to SUM a range of cells where the range for rows and cols for the formula come from cell input ? In the below example : I am looking for a formula to use...

Hello all! I have a master price list that has all my SKUs and Retails across multiple vendors. Each worksheet is titled with a different vendor as the sheet name. I am trying to update our inventory with the new retails, and need a function that can match the SKU and retail across all the...

I am having an issue with writing the formula for the following. IF A equals a certain DATE of the year (for example the 1st of every month) then B is "JACK" AND IF B is "JACK" then C= 80.00 1st - Jack = 80.00 2nd - Tammy = 20.00 3rd - Lisa = 60.00 4th - Laurie = 500.00 5th - Christina =...

Hi there: I have a column which is labeled "Date Assigned" in which I enter a date eg. 1/10/2014. I want to total the number of occurrences of a month in this column based on what I have chosen in my pick list that lists all the months, however only if we are in the current year. This column...