



1 
84 


IF + IF? by
RoadKill
Is there a way to combine the IF Statement. I will be using a similar formula
for six separate metrics so would be great if I didn't need to build a table...

August 29th, 2008 01:58 AM
by JMB

7 
61 


IF question by
Stuart
Hi,
Can someone help with the following conditional IF question please:
If value in C4 is numeric, then the formula for K4 is C4*J4 rounded to 2
places
or...


3 
64 




4 
110 




3 
97 


Offset formula by
Joe_Hunt
I've been trying to find an answer to a question I think I should know the
answer to with no luck. I hope someone can help me. I need to have a formula
change...


2 
131 


Calendar List to Calendar format by
Kristin
Please help! I have been asked to maintain a calendar which lists calendar
items and sorts them by item type on one sheet and then links those items to
a...

August 29th, 2008 12:20 AM
by Pete_UK

3 
129 



August 29th, 2008 12:04 AM
by Saylees

4 
444 



August 29th, 2008 12:02 AM
by Max

5 
133 


vlookup returning zeros by
Cobaum
I have a vlookup formula that I copied down a column. It works fine on 95%
of the values, but for some reason, right in the middle of the column it is...

August 28th, 2008 11:43 PM
by Max

5 
75 


Percentage formula needed by
MJM
I have not used Excel formulas for a while (need to take a refresher course)
but in the meantime I am in need of the formula that will calculate the...

August 28th, 2008 11:25 PM
by MJM

5 
79 


need help with a formula by
freeman
I have an excel file that looks like this.
Column A has a long list of names, many that repeat
Column B has a the following formula =COUNTIF($A$2:$A$7610,A2)...


8 
81 


#Missing by
Shirley
Hi,
I am using Hyperion Smart View  similar to excel.
The cells have formula which are suppose to be zero amounts, display
#Missing, instead of 0 or  ....

August 28th, 2008 10:22 PM
by JLatham

1 
90 


similar names  two spreadsheets by
jtkuehn
I have two spreadsheets. 1 has the names of new customers and 1 has names of
prospects. I want to figure out if a prospect became a customer, but the
names...


3 
89 




1 
104 


=SUMPRODUCT Col E = B, Col F = blank by
77Debbie77
I am using the formula below to try and get the total count of Col F when it
is blank (Col F is text data and some employees did not enter a comment) when...


7 
87 




5 
84 




2 
103 


weighted average by
elaine9412
Thanks for my previous help. Now I have the data and I need to do a weighted
average for different groups of data as follows:
group 1:
Total count 3 total...


6 
75 


#NAME? by
77Debbie77
I am pulling my hair out!!! I have over 60,000 rows of data with comments and
am trying to add a function to a cell: =SUMPRODUCT(('Closed calls as of...


5 
92 