Get instant live Excel expert help with IF AND Functions

9. Switch to the Employee Summary worksheet and calculate the totals in the table using the appropriate functions. HINT: Remember that sumif multiple criteria adds or totals cells only if they meet the specified criteria, and AVERAGEIF and COUNTIF perform their computations only when the data meets multiple criteria.

Hello, I need to figure out how to link a cell in one sheet to a cell in another sheet, but those cells need to link if and only if they have the same part number in a different cell how do I do this?

I need help with an IF AND formula that will place a number/mark in each cell if the time is between two different hours AND also place an L for lunch intervals, and B for break intervals. This will be on a 15-min interval. Formula is in attached file starting in column DT5

I need a IF and IFERROR formula for column H.

Hi I have column of registered attendees to an event and then a second column of actual attendees. i need to be able to identify what attendees attended and those that didnt. i have tried applying conditinal formatting but it does not account for any variations in fonts or spacing. i also tried IF and Vlookups but i cant get anything to work.

I need help to get rid of #DIV/0! in a spreadsheet where I am using the following formula: =AVERAGE(DF34,DI34,DL34,DO34,DR34,DU34,DX34) If there are no numbers in the specified cells, this formula is returning the value of #DIV/0! and I would like to have it either be 0 or blank. I have tried the IF and IFERROR function but am not placing this IF formula in the correct position to the =AVERAGE function. Please HELP!!

I need help with if and statement excel I am unable to apply it

Hey Guys, I have a problem. In my database, i have several injuries mentioned (eg.: head,half-head, nose, finger, hand, torso...), all injuries are written down in one cell. Most of the time, the medical personal writes down all parts of the body mentioned. I wand to find out, how many injuries in a special group of injuries have been attended within this year. Group 1: head, nose, eyes... Group 2: hand, finger, arm... With countif and sumproduct i only get the number per injury. How can i avoid double-counting? E.g. there are 25 injuries on half-head and 31 on head. (6 whole head + 25 half-head)... Thanks in advance!

I need a formula that will perform MIN on a specific region. I have a FID that is the name of my series of data. I want to perform a MIN only on the data that corresponds to the text in column FID. Using IF and MINIF, this is complicated and gives very big formulas. I show an example in column G (headers:Y) of the calculation I want to perform. I need a less complicated formula.

Using named ranges, create a formula in cell G4 to display YES if the number of at-fault claims is greater than one and the current rating is greater than two.Both conditions must test true to display YES; otherwise display NO in the cell. Hint: Use a nested IF and AND formula.