
The problem I run into with this formula is that I have to recreate it whenever I insert another row. I would like to simplify it so that it will be easier to update... or (even better) for Excel to automatically adjust the formula when I insert a new row. Please advise... =SUM(IF(K7="HP: Full Time...

HI, To all Skilled Guys, Skill is a beauty and it has always a flavour to amaze others. Can I please have a soilution of a formula from any skilled one out here! Thanks for your help. My query is: If Cell A1 contains "S" and cell B1 is greater than Cell G1 then Cell J1 (B1G1) should be positive...

Hi. I need help with a type of counting problem. I have a huge excel data file with over 50,000 data entry points. It is forex data. I have a list of several banks. And their trade dates, and a bunch of other information columns that are cost, volume, what currency traded in, and more complicated diagnostic...

Here is a typical row in the spreadsheet which is nearly 4000 rows of data: Description WBS WBD Material Qty Mea Size  Ball Valve, V600, 02  C12DO  F1804B  CARBON STEEL, PIPING  12  EA  1"  Im trying to use the "Description" & "WBS" columns for the criteria to match...

I have a sheet containg two columns, frmatted as currency and to show negative numbers ehere approriate. e.g £25.00 One colum shows a positive number of £3.00 (Cell A1) whilst the other shows £1.00. (Cell D2) When I do the =SUM formula as =SUM(A1D2) I get the result of £4.00...

Hi all With the data below : how can I sum the last 10 cells in the row from 211 (row 1=32) and (row 2=25) Data is added to columns 12 to ? at a later time. Derek 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 1 5 0 1 4 1 7 2 4 7 3 5 2 2 2 2 3 2 3 2 2

MaxPhillippe You reference across sheets like so =SUM(Sheet1:Sheet10!A1:A2)