counta formula

I'm using the following formula, but I do not want it to take into account blank cells or null cells. =COUNTA(Monday!L5:L11,Tuesday!L5:L11,Wednesday!L5:L11,Thursday!L5:L11,Friday!L5:L11,Saturday!L5:L11,Sunday!L5:L11) The above cells also have the following formula...

Hi all I've got a formula which is designed to look at a target value and match all the customers who have that target value. It works perfectly up to a certain point, whereby it returns incorrect values. By this I mean that it returns a match for each customer in the database (when it should...

I have defined list to select rows from A8 to last value in column A (but before A100) =OFFSET(sb!$A$8;0;0;COUNTA(sb!$A$8:$A$100);1) How to do exaclty the same, but select area like: A8:C100? When I did like: =OFFSET(sb!$A$8;0;0;COUNTA(sb!$A$8:$C$100);1) it's not working.

Hi, This is my first post! Hopefully I'm doing this right! Thank you for your help! I'm working on a spreadsheet to track shift requests - my issue is that one request can request for multiple shifts. I've created a system to generate request numbers but I'm looking to count the number of...

I am currently trying to use the COUNTA function in Excel 13 to find the number of cells populated with data. When I execute my code it is supposed to insert the formula into the selected cell that would refer to other cells for the counting process. When it does this I am asked to open a file...

I would like to be able to copy formula down to sum amounts in COL B based on how many text values in COL A. I have searched to no avail. Is this possible without VBA and without array (would prefer to avoid volatile functions if at all possible)? (Can't use these when uploaded to secondary...

Hello, I have a formula that excludes certain text in cells, and counts everything else- but I want it in addition to counting the cells that exclude the text, sum up the costs in the next column. So far I have this which works in counting all the cells that DO NOT contain the texts...

Hi, I have atable which can grow in rows, and the columns will stay the same at 10 columns I want to add a dynamic named range called BenefitsData. I tried this: OFFSET(B7,0,0,COUNTA(B7:$K$200) and get no error but when I try to use it in my INDEX formula as the array argument I get #VALUE...

I am using =COUNTA($B$2:$B$4000) to determine the number of cells that are not blank in cell range B2 through B4000. Row one is a frozen row so it always remains visible if that matters and the COUNTA is in cell B1. Every time I insert a row anywhere in the range B2 to B4000 it changes B2 to B3...

I am trying to use this formula =IF(COUNTA(BMWANP!$B3:$J3)<>0,"X","") to count if any data is in a separate tab (this example uses "BMWANP" for the tab name) and if it is to mark an "X" in that cell otherwise leave it blank. I copied and pasted this formula and a window pops up that says UPDATE...

I'm looking for help writing some VBA code. I have a spreadsheet has the complete file paths to different workbooks. I'm trying to write VBA code that will reference the file path on my spreadsheet and return the number cells in a particular column from that workbook using the =CountA()...

Greetings coders! I have a problem. My workbook contains two sheets appropriately named Data Dump and Formatting. Within the Data Dump, I want to establish the amount of rows by using CountA("A3:A50"). For the sake of this question lets say there are 5 data rows. I want to set my print area on...

Can you combine "CountA" with "IF" and how is this done? I need to find the number of occurrences of a specific word, i.e., "textbook" in a specified group of cells. Thank you.:)

My PC is running out of resources because i have used multiple countif, sum statements for dynamic ranges and i am trying to use macros instead : e.g. =SUM(OFFSET(KTPT81T!G5,0,0,COUNT(KTPT81T!G:G))) the data orginates from sheet 126 and i need the sum to be displayed in sheet 1 column Y2...

Hi everyone, I am having trouble with my formula. I want to count non-blank cells using the COUNTA function. I want to count non-blank cells in a column in a different workbook. The workbook I want to count from is named "File1.csv" and it is open. If I type in the following formula it...