Search results for query: *

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 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...

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...

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.