Search results for query: *

Thanks Skip, Once again you've easily solved my problem and I really didn't think the formula would look that simple. On a side note I've never used and &0 in a formula, what does it do.

Sorry for being vague and I don't have URL's to attach files or pics. I have pricing in column K and counts in column V. I'm trying to sum the counts in column V if there is not a blank cell in column K. So for the sum answer I'm looking for is 90. K V blank 10 $100.00...

Hi All, I have an Excel spreadsheet with columns that have pricing in some cells, but some of the cells may not have prices in them. I would like to sum the numbers in column V1:V28 if it has a price in column K1:K28 and put the formula in cell K30. Thanks in advance for all who help

I have a new rate that I have to add for a calculation spreadsheet, but I can't figure out how to integrate it using existing IF Statement formulas. I have 4 rates for a class; rate 1 is a standard rate, rate 2 is a discounted rate for primary service, rate 3 is a discounted rate for primary...

Hi, I'm linking data from multiple spreadsheets into a summary excel spreadsheet. The data in the cells links fine, but I would also like to have the comments from the original cells linked as well. Is there any way to have the comments from those cells show up in my linked summary spreadsheet?

Hi, I'm linking data from multiple spreadsheets into a summary excel spreadsheet. The data in the cells links fine, but I would also like to have the comments from the original cells linked as well. Is there any way to have the comments from those cells show up in my linked summary spreadsheet?

I need the date from the left hand column B and I will need to know the hour H# in row 1. The request is for the top ten highest values and they want to know what day and what hour they occurred. I need to know how I can get the top ten highest, what day they occured and what hour they...

The large function works, but what conditional format can I use to find the date and hour associated with it.

The top ten highest.

I have a worksheet with 20 years worth of data and I was tasked to find the top ten load data values for the entire worksheet. Here is an example of the spreasheet. The H# is the hour and it goes up to H24. CompID Dt H1 H2 H3 H4 H5 1 1/1/1989 142 124 117 112 112 1 1/2/1989 134 120 115...

Skip, Thank you so much, it worked and I'll use named range headers in the future. Carl

I'm a little confused and I don't seem to have put the right formula in. The formula I came up with using what you put was: =INDEX(INDIRECT(B1),MATCH(MAX(A2:A1018),A2:A1018,0),1)

I have a spreadsheet with multiple columns/rows of data. I need to find the max of one of the columns and the data in the other columns that are in same row. I've found the max, but I want to reference it in order to find the values of the other columns in the same row. KWH KVARH KVAH PF...

You were correct and thank you for your help. I was using the formula =SUMIF(L2:L67,">0",M2:M67)/COUNTIF(L2:L67,">0",M2:M67). It worked perfectly when I deleted the third parameter. Oh and Skip, I misunderstood which formulas you wanted to see. Thank All of you for your assistance.

The Load Factor formula is =SUM(range values)/(Max(range values)*(24*365)). The Savings formula is =(B2-C2)/B2. Some companies have negative Savings.

The percentages are Load Factors for companies. Each class has an average Load Factor and within that class each company has their own Load Factor. I would like to take each Load Factor whose Savings is greater than zero and average them.

It doesn't work. The COUNTIF statement errors out everytime. It says there are too many arguments for this function.

I know you can do SUMIF or COUNTIF, but I would like to do an AVERAGEIF. I have a spreadsheet where I only want to average a group of percentages from column "M", but only if the amount in column "L" is greater than 0.