Hello, I have the below formula, but don't understand why the last part of it ,">"&0),""). Can somebody clarify pls? =IF(COUNTIF($AJ$2:$AJ9,$AJ9)=1,COUNTIFS($AJ$2:$AJ11323,$AJ9,$AQ$2:$AQ11323,">"&0),"")

Hello, I have the below formula, but don't understand why the last part of it ,">"&0),""). Can somebody clarify pls? =IF(COUNTIF($AJ$2:$AJ9,$AJ9)=1,COUNTIFS($AJ$2:$AJ11323,$AJ9,$AQ$2:$AQ11323,">"&0),"")

Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have to add a formula in each of the daily sheets that will sum a range of cells. I want to create the formula in the first page and then copy it to the rest. The result needs to have each page r... Read more

Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have to add a formula in each of the daily sheets that will sum a range of cells. I want to create the formula in the first page and then copy it to the rest. The result needs to have each page r... Read more

Hello, I have been searching and found several discussions similar to this. However none have them were exactly the same and I haven't found my answer yet. Would appreciate it if someone could help. In need C9 to fill out red if any text is entered in B9 I am sorry if this is already answered and I did not find it. Many than... Read more

Hello. I'm working on an Excel sheet, where the entire row is colored based on the values of two cells in the current row. If one of the cells in the row is marked with an "x", the whole row gets one color (green), and if another cell is marked with an "x", the whole row gets one color (red). This is OK, and I made that rule work pe... Read more

Hi, I have a workbook that contains 32 worksheets. 31 identical sheets that are basically days of the month. Last one is a summary sheet. I have to add a formula in each of the daily sheets that will sum a range of cells. I want to create the formula in the first page and then copy it to the rest. The result needs to have each page r... Read more

Hey~ I need to count the number of times a number appears in a spreadsheet. For example, how many times the number 1 appears in an entire spreadsheet. I have the formula =COUNTIF(B6:M59,"1") but that only tells me how many times only the single digit 1 appears. I need to count how many ones total even if it appears in 11, 16, 21, 51. S... Read more

Hello, Hello, I have a small query related to Excel Search function. Suppose I need to search the below data in target cell which has some errors , but a partial match of data is being accepted. Which function can we use as I have tried Match & Vlookup it only searches for exact data. Is there any function for partial match of ... Read more

dear sir/madam i am looking for excel work for school report card, one sheet where i want to put data as where data will be entry(sheet-1) class-I subject roll no name neglish-1 english-2 beng math physics lifescince geo hist drawing total average GRADE 01 ANISH ... Read more

Hello, Please I want to know how I can add 200 working days to a specific date to get a new date

Hello, How do you change cell colour automatically based on date. I am trying to set my training spreadsheet so I can clearly see when staff members are due or have upcoming training. I am looking to do the following: Overdue Red Due to renew in 30 days Orange In date ... Read more

Hello, Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the student, the date and the amount paid. For example: date # name amount paid jan-1-2018 288478 Ricky $300 jan-2-2018 288479 Monica $3... Read more

Hi All, I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain text. There is solution around it? Thanks

Hi All, I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain text. There is solution around it? Thanks

Hello, I need a equation for subtracting amounts that i entered from a fixed amount. Here is my screen shots. I enter 10000 in row 1 column A Then i enter 500 in row 2 column B That time my subtracted amount will be show in row 2 column C(Ans:9500).Then again i enter 200 in row 3 column B the answer 9800 will show in row 3 column ... Read more

Hello, I need a equation for subtracting amounts that i entered from a fixed amount. Here is my screen shots. I enter 10000 in row 1 column A Then i enter 500 in row 2 column B That time my subtracted amount will be show in row 2 column C(Ans:9500).Then again i enter 200 in row 3 column B the answer 9800 will show in row 3 column ... Read more

Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits within a certain year PER site. Please see a sample of my database below: Site Site Report Date Year Visit Reason ID Name ID 3 MO 39 17/03/... Read more

Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits within a certain year PER site. Please see a sample of my database below: Site Site Report Date Year Visit Reason ID Name ID 3 MO 39 17/03/... Read more

Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits within a certain year PER site. Please see a sample of my database below: Site Site Report Date Year Visit Reason ID Name ID 3 MO 39 17/03/... Read more