counta

Hey Guru's!! I've done a counta =COUNTA(L4:M10000) which gives me every cell with data. but ....... I also need unique's in that if L4 and M4 both have data it's only counted once? I know it's going to be something simple that i'll smack my forehead in shame for after but you guys always...

Hello all, I am writing a simple macro to count the number of categories in a dynamic range by: Offsetting the bottom of the range (“SectionInfant”) by -1 CountA the resulting range (B4 to Target) Paste the resulting number in F1 I can’t get the following code to work. Any help is...

Hello. I'd like to figure out a formula in a single cell that returns an array of counts rather than an overall grand total count for a given list of columns. Example. If I have the following 3 columns and four rows: x x x x x x The answer I am...

hy i want to count cells not empty in each column to use in functions presently i have row 1 with this information, each column have a counta function (data starts in row3) is there a function or and array formula that would return this array to use in other functions? (allowing to eliminate...

Hello- I have the following data set, which I'm trying to calculate the time spent based on =CountA of the items (columns A-E below). <tbody> Col. A B C D E F G H I Item 1 Item 2 Item 3 Item 4 Item 5 Total Time Spent (mins.) Time Spent - Item 1 Time Spent - Item 2 Time Spent - Item 3...

In cell C2 of sheet1 the user enters the row number of the header row for the 'new_report' tab. I need to count the number of header columns based on which row number the user enters (i.e. user enters 3 then COUNTA row 3, user enters 5 then COUNTA row 5 etc.) The formula below was my attempt at...

I have created a Pivot Table using Distinct Count. The issue I have is the Grand Total number does not match to the number I get if I do a COUNTA for that column in the Pivot Table. Any ideas? Thanks

in a few quick words, how am I thinking wrong when I use Application.CountA(ActiveCell.EntireColumn.select) to return the incorrect number of 1, versus Application.CountA(ActiveCell.EntireColumn) to returna the correct count of 109 in my particular spreadsheet? I know I don't need to...

I have a COUNTA formula running and returning results correctly. I want to amend the formula so that an exclusion is not counted. In this case, i am counting all cells with values in a large range, but i want to exclude a particular value. COUNTIF with exception would not work for this case...

Hi! I have a sheet that uses data from many other sheets. I.E. IF(A1="";"";A1) Later on i get in trouble when i use the COUNTA formula... because Excel somehow thinks that "" is a blank space and counts that as a letter. This makes my "COUNTA" go nuts... (me as well) Any other expressions...

I am having difficulties in finding the right formula to return a number of completed tasks. I am working on 2 sheets, the first is an overview sheet giving a headline of outstanding and completed tasks for individual projects. The second sheet is a full task list for each project. I want to...

Hello, I am trying to get this nested IF formula to work, however it keeps returning FALSE. Any help appreciated. =IF(D3="Monthly",IF(COUNTA(E3)<1,"Action Required",IF(D3="Hub Contact",IF(COUNTA(E3)>1,"Action Required",IF(D3="Bi-Monthly",IF(COUNTA(E3)<>E3/B1,"Action Required","No Action"))))))...

Hi all, I have a dynamic variant array that is populated via a table column in a sheet. I need to add to this array with the contents of a column in another sheet. I would post the current code but on my mobile at the mo. The 2 columns in question change values on a daily basis so I have...

hi everyone... I need a formula that will average the values in column AA ONLY if there is a student name in column C. The name is obviously unique for each student so i am wondering if countA would be part of the formula. thank you!

All, ran into a snag and it might be the 2 combined or the ref cell. Hope someone can help. Here is what I have. =SUMPRODUCT(--(INT('Line 3 data copy'!B4:B44739)=INT('Line 3 calc Sheet'!B3)),COUNTA('Line 3 data copy'!O43:O48576)) Returns #value B4 is a date 8/1/17 11:15 B3 is a date 8/1/17...

Hi Everyone, I'm working on a Rent Roll for a Real Estate Underwriting Model. In included growth rates in my model, which have different start dates depending on when a lease is rolling over. Since I'm multiplying my base rent with a rate and want to increase the base rent with the same growth...

My VBA code populates 3 different sheets in loops by column by column. The first column of first sheet populates from an existing table. Next, the first column of the second sheet looks at the first column of the first sheet and uses that data to make a decision for what it will populate with...

Hi everybody. My first ever post. Would anybody know how to return a counta possibly using index and match? Or is there a better way. I have a table to record when people are on leave. The column headers are Grade / Team, Name, Staff Number, then the rest are dates in DD/MM/YYYY format and...

Here's probably an easy one for you experts. I need to count the non-blank cells in a row. The twist is I'd like the formula to also figure out which row to count from. In my sample workbook, I have the "Overview" worksheet, which contains the rows of the table that needs counting. I have a...

Hi, I am working on cricket points table, My table goes like this. Match Schedule <tbody> 1 Home Team(A1) Away Team(B1) Result(C1) 2 RPS KKR 3 RCB RCB 4 KKR KKR </tbody> Points Table <tbody> 1 Teams(E1) Games Played(F1) Wins(G1) Points(H1) 2 RPS 3 KKR 4 RCB 5 GL...