Are you stuck on Excel or Google Sheets?

Need to average values from cells in column B that correspond to matching criteria in cells in column A. Averageif function returning #DIV/0

Hi please see the formula in column AU on the attached. I am trying to work out why I get #N/A whenever the value in AP = "No Work Orders". Is it something to do with the fact that this comes from the formula in AT?

Could you help me with Column A "Date of Sale" Column B "Sales £" What is the excel formula for sales in january, sales in geb, sales in march etc etc? Many thanks

I need to use birth date in one column and date of entry into program in another and round to the nearest tenth decimal

How can I check for duplicate phone numbers across these 5 columns but still keep duplicates that are from one column?

I need a formula to calculate the MAX of a range of 167 rows in column D, then find the MAX of the next 167 rows in column D and so on continuously through the entire sheet. Example MAX D2:D169, D170:D337, D338:D505 etc...

hi i need to change all the numbers in a column to negative ones?

Hello, I obtained an .xls file that I need to do work on and at least one tab that I am working on finishes in column IA. Other tabs finish in column IV, which is the higher limit to the right for .xls files. I have converted it to .xlsx and the above did not change. How can I view up to column IV at least for the tab that goes up to IA? Thanks in advance. Demetrios

In column A I have 1500 lines of data, some of these are valued at zero, I need to write a formula which removes the values of 0 and then gives me a sum of the unique names in column b. I am aware I could filter column a to remove "0's" and then remove duplicates from the remaining cells in column B, but this must be done in a formula

I need to multiple a column then round to the nearest 9 whole dollar while staying in a single column so i need to take the product then round it to the nearest 9