Menu

# Mazzaropi 134

Contributor
Registration date
August 16, 2010
Last seen
April 5, 2018
Contributions
626
Gender
Male
Location
Belo Horizonte, BRAZIL
Signature
Belo Horizonte, MG - Brasil. Marcílio Lobão

## ,">"&0),"") at the end of a countif formula

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),"")

## ,">"&0),"") at the end of a countif formula

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),"")

## Copying formulas to multiple worksheets [Solved]

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

1
Thanks
Answer Excel

## Copying formulas to multiple worksheets [Solved]

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

## Highlight cell if another cell contains any text [Solved]

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

3
Thanks
Answer Excel

## Copy conditional formatting for an entire row based on one cell [Solved/Closed]

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

65
Thanks
Answer Excel

## Copying formulas to multiple worksheets [Solved]

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

1
Thanks
Answer Excel

## How to count how many times a number appears in a spreadsheet? [Solved]

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

2
Thanks
Answer Excel

## Excel partial match [Solved]

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

## School report card with data of all classes

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

## How to add 200 working days to a given date. [Solved]

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

1
Thanks
Answer Excel

## How do you change cell colour based on 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

## Data showing who pays a doesnt after manually input receipts [Solved]

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

## Row conditional formating in Excel [Solved]

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

1
Thanks
Answer Excel

## Row conditional formating in Excel [Solved]

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

## Subtracting amounts from a fixed amount

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

1
Thanks
Answer Excel

## Subtracting amounts from a fixed amount

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

## Counting sites visits within a year [Solved]

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

1
Thanks
Answer Excel

## Counting sites visits within a year [Solved]

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

## Counting sites visits within a year [Solved]

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