Get instant live Excel expert help to learn how to find range in Excel

Set the following conditions in the Criteria range: *Sold-out Limited Edition Canvases (Yes in cell H8) released after 1/1/2000 (in E8) and before 12/31/2003 (in F8). *Sold-out Limited Edition Prints (Yes in cell H9) released after 1/1/2000 (in E9) and before 12/31/2003 (in F9).

Create an advanced filter using the database list and criteria range. Filter the records in place. In cell C2, enter the appropriate database function to calculate the highest estimated value of the filtered records.

i am having trouble with a median calculation with nested if criteria. i need to find the median sales price within a date range. last time i tried excelchat was having technical issues with downloading so trying again.

I Am using a Sumifs formula , so i have created for date range with 2,3 cell, but when i am adding new name the formula have to copy and special paste (value), now i want to auto update the cell value with formula cell refernce. formula is =Sumifs('A'!B:B,'A'!A:A,">="&B3,'A'!A:A,"<="&C3) SUMIFS(CELL NAME RANGE,CELL VALUE,CELL NAME RANGE DATE RANGE)

I have a problem regarding to Sum range with INDEX

Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will receive no additional deductions

i have array of two columns which i need to multiply and then sum of the product subject to if a value in 3rd column falls in a specified range so for eg A1= 5 B1= 10 C1=5 So if C1 lies between 0-5 then multiply A1*B1 and does this for an array of all values in A1 & B1 and them sum the values

Go to the Earring worksheet and complete the following steps: Sort the table by the Material field in ascending order. Convert table to spreadsheet normal range. Insert subtotals into the range A2:G25, with the subtotals appearing at each change in the Material column value. The subtotals should use the SUM function and include subtotals for the 2018, 2019, and 2020 fields. (Hint: Make sure to check the summary below data check box if it is not checked automatically.)

I need help with an excel IF logic formula. I have a range of cells that are numbered between 1 - 100. I want to bring back in the cell next to the number, if it is below 3 the word "basic. If it is between 4-6 the word "moderate'. and anything over 6 the word high.

I need to create an intake portal. I want the user to enter details in a form, click a macro/vba button and consume the data and paste it into another spreadsheet in the same workbook within a range of cells that are not empty.