I would like to know if possible that when I highlite row 22 upto 34, only the cell's in these rows will be added.

On the table below, I want to count how many times did we purchase washers in February of 2007. How can I write this in SUMPRODUCT FUNCTION? Please help....

I am trying to find costs associated with certain project numbers and do two different things. One, sum the positive numbers, and two, sum the negative...

I have a list of book titles that came over all in one cell. I would like to separate them into individual cells, one title per cell. They are separated into...

I am trying to create a workbook with 52 sheets, one for each week in a year. There needs to be a column for each day of the week on each sheet. I want the...

Hi, I have two cells, and I divide them, but need to set another cell that would: if the number for the divides cells is infinite that it would show 0. How...

I would like to have a CBR show up as a ratio expression not as a integer value after the division. How do I do this? --

How can I finesse SUMPRODUCT to ignore hidden columns? For example with column G through M hidden, column D contains resource names, and column F through AE...

I am building a form for users to use to submit data. Part of the data needed is Lat/Longs. Some of the users use decimal degrees (preferred) and others use...

Hello to alll I have 5 codes (contain text and number) in a column: A1= F 01 01 A2= F 01 02 A3= F 01 03 A4= F 01 04 A5= F 01 05 But they are not completed at...

When using: =COUNTIF(A2:A8628,A2) and select all ‘1’s from the Filter to obtain the Unique records my count on these records was 8193. In looking for a...

Hello to alll I have 5 codes (contain text and number) in a column: A1= F 01 01 A2= F 01 02 A3= F 01 03 A4= F 01 04 A5= F 01 05 But they are not completed at...

I'm working with a new spreadsheet project in my company and am having an issue. When I press F9 to update the formulas, it replaces every single formula...

I'm trying to create a new shifttime based on the original shifttime and some overtime hours. Let's say somebody works from 07:00 - 15:30 and is doing...

I have a worksheet which has a column called File date and another column called response due which I would like to calculate based on the File Date column. ...

I could use some help with the NETWORKDAYS function in Excel. First, I want the formula to calculate the number of work-days between two dates and subtract...

How can I finesse SUMPRODUCT to ignore hidden columns? For example with column G through M hidden, column D contains resource names, and column F through AE...

I've got a co-worker trying to update links (by changing the linked workbook) in an Excel 2003 workbook. Whenever she selects the file she wants to link to,...

I need to keep track of how many dates the local swimming pool is open. When I type in a date (for instance, May 15) in cell A1, I want cell B1 to tell me...