My excel seems to be handling cell referencing correctly. It is keeping the old value and not updating the cell with new information. Example I type 100...

Trying to check 2 columns and if I find "Auto" in column A and "January" in column C then I want to add the money value in column E to a budget total ...

I have assets under management for 5 portfolios January - october 2007 two portfoios opened in June of this year. I need to calculate weighted average of...

Hi I am getting steadily to grips with excel's more interesting functions, but am definitely no expert! I have a spreadsheet with the following...

G'Day, Ive got a problem Ive been working on for about 6 months and need a hand cause I cant think anymore! Ive got 7 columns, with about 400 rows of data...

Can someone help me create a macro that will search for a lowercase letter immediately followed by an uppercase letter and then insert a character in between? ...

Problem: Cell A1 is data entry =quantity on hand Cell B1 is data entry = quantity sold Cell C1 is data entry = quantity received Cell D1 is formula = new...

I am using the following formula with works great, but I need to add something to it. =IF(AND(TODAY()=C35,TODAY()=D35,ISBLANK(G2)),C2+I2,"") In addition...

TECHNICS U EVER DREAMED OF .... The 101 SEX AND ROMANTIC SECRETS and TECHNICS E-BOOK This SECRETS and TECHNICS are right for you if: 1. How to try to get...

TECHNICS U EVER DREAMED OF .... The 101 SEX AND ROMANTIC SECRETS and TECHNICS E-BOOK This SECRETS and TECHNICS are right for you if: 1. How to try to get...

TECHNICS U EVER DREAMED OF .... The 101 SEX AND ROMANTIC SECRETS and TECHNICS E-BOOK This SECRETS and TECHNICS are right for you if: 1. How to try to get...

I'm encountering a strange issue, I was hoping that some experts here might be able to help. If I enter the formula: =SUMPRODUCT(INDIRECT("A1:A2")), and put...

I work with mailing lists in Excel, and sometimes I run into wrapped text that when I unwrap it, it results in line breaks (little boxes) within cells that...

I use a lookup function in excel to pull data for selected users. When the user is not listed in the range, the result is #n/a. Rather than selecting each...

I have a table containing Date of Invoice, Customer #, Sales Dollars, Sales Rep#. Using Sumproduct I was able to extract if the same customer has multiple...

Hi, How do I get rid of #DIV/0! in my cell when I used the following formula? =IF(Q3="","",1-(Q3/F3)) I have tried everything and it still shows up in my...

My workbook consists of two worksheets, several columns are governed by a formulas referencing both data columns in one, the other, or both worksheets. Some...

I am trying to count the Maximum Number of Blank Cells between Non Blank Cells in a Range. e.g. Range A1:a13 a1 - 2 a3 - blank a4 - blank a5 - 24 a6 -...

if a is less than 4500 then b, if a is greater than or equal to 4500 but less than 7500 then c, if a is greater or equal to 7500 then c

Wilba wrote: Bob Phillips wrote: =COUNT(1/FREQUENCY( IF((A2:A6=--"2007-10-02")*(A2:A6=--"2007-10-03"),B2:B6), ...