Get instant live Excel expert help with ROW Functions

I have a matrix with Y/N answers, each row has a value, I need a formula to calculate automatically the total value for each column

HI, I need to verify that a formula I was given is going to work correctly. I have a 200K row spreadsheet and the results are not producing what I expect. In a small file that was used to test the formula, it appears to work. The formula is =SUMPRODUCT(($A:$A=A2)*(B2>$B:$B))+1 I need to take value in A, compare it to value in B, and then in the next column, rank the items in B numerically. However, the values in column A and B frequently change. So there may be results 1, 2, 3 or 1,4,5,3,2 (I will need to sort to get the results in numeric order). I do know sumproduct is an extremely resource intensive formula.. Thank you.

I just need to sum the numbers in a row. First time user.

Can you tell me how I can print row 2 on each page

Create a new conditional formatting rule that displays any Inventory Value for the Food & Health department with a value of $30,000 or more as Red fill color (second column, last row).

I have a table with samples in each row, and examination dates for the columns. The cells contain damage type. I need to make a table with rows as the samples, damage type as the columns and the cells being the date in which they first appear. To make it harder though, the cells often contain multiple damage types e.g discolouration and fungus. Any idea how I can make my new table? I want to make the new table because I'm interested in making a graph for each damage type showing the average length of time until the damage was exhibited for my different treatments.

Currently using the below vba code to date stamp in a specific row when a worksheet is updated.I would like it to show the seconds as well as the Hours and mins.I would also like the date stamp to be blank if no data is present. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row >= 3 And Target.Row <= 1000 And Target.Column >= 4 Then Cells(1, Target.Column) = Now() Cells(2, Target.Column) = Application.UserName End If End Sub Thanks

In the Profit Analysis worksheet: a. Create a Pivot Table using numeric data from Profit column. b. Display the total profit for each of the four classes of cars. c. Display the total profit for Airport as well as the Downtown location. d. Row and column calculations (sum) are required so that the total profit for EACH location and the total profit for EACH carclass are visible in the pivot table. There must be a grand total (sum) that represents the sum of ALL profit.

Hi, I have this speadsheet which is not working. There is a formula in coloumn Q which is meant to say if the data in F, H and O match then say Duplicate. how this is not working properly. Foraxple if you look at row 3 & 4, this is working as the posting date, narrative 2 and amount match. but if you look rows 6, 7 & 8 the data do not match but its showing duplicates and if you were to delete the data from b11 to o11 and the same for row 12 the forula behavours funny.

I need row 1-5 one long length, then the rest of the rows to be shorter columns. How do I format these differently?