counta

  1. M

    =IFERROR() "value_if_error" incongruity

    Hello there. New poster here, so I'm nearly guaranteed to pose an already-asked question, I suppose. I did search for it though! I'm using Excel 2007 with Windows XP Professional Ver 2002 SP3. Here's a basic version of a table I'm working with. <tbody> M M M M M SM C C C C C SC...
  2. B

    CountA in VBA using activecell.row to set the range

    Please help! I am trying to enter the worksheet function CountA in a whole column to count how many blank cells exist in each of the rows. I have a for each loop which will work down the column but I can't figure out how to get the formula (or result) into each of the cells. I have nicked...
  3. R

    don't understand this offset

    Hi I am working towards a chart with a scroll bar in excel 2002 showing 32 data entries/rows. My data range is I46:O178 with the labels in A46:A178. I've been following this tutorial Dynamic Charting Formulas in Excel plus some other sites for the control toolbox scroll bar. The dynamic named...
  4. T

    Return Multiple Filtered Lists from Table with Blanks on Separate Worksheet

    I have a list of song titles in Col A, and several column headers of 'categories' or 'themes' in Row 1 (ie. 'Christmas', 'Advent', etc). For each song, I put an 'x' under each column/theme for every theme that is found in the song (ie. 'Christmas, Advent, etc). Data Table...
  5. G

    COUNTA: Calculating Dynamically Changing Rows

    Hi All, I am a bit of a newbie to Excel's formulas so apologies in advance for incorrect use of terminology. However I have an issue that I was wondering if anyone could help me with. I have a report that varies in row size daily, and I need to count how many employees we have in that one...
  6. J

    Countifs

    I would like the 3rd criteria of a COUNTIFS formula to count cells that are not blank (with text). I have tried ">0" and it does not work since the information is texts. Can I somehow add COUNTA or use another method to count cells that are not blank?
  7. D

    VBA AutoFill Varying Rows of Data

    Hello everyone, I have an Excel workbook that has multiple sources of data that vary depending on the day. I am running into a problem with the equations refering the data giving me a #REF error when the number of data rows decreases. This is fairly easily corrected manually by selecting the...
  8. C

    Insert Rows off a "counta" formula via Macro

    Need some help getting this into VBA I have searched a couple of times not found exactly what I am looking for; I have a tab called "Excluded" and another called "Reconcilation", in the excluded tab I have a pivot that has been copy/pasted special. I am trying to "counta" the number of rows and...
  9. K

    find row then use info in formula

    Here's what I want to do. I have a teacher schedule and I currently have a formula to count the number of times they cover a class : Teacher Name | =COUNTA($C$86:$Z$86) This works great, but I have been manually entering the row data according to the teacher name. I would like this to work by...
  10. K

    Counting Query - Excel 2003

    Hi all -i'm brand new to this board (though I think i'll be on here quite a bit! :)) I have a problem in excel that i just can't get my head around, i'll try to pose the question as simply as possible as trying to explain why i need this is a bit of a headache!!! Basically, i have a list of...
  11. M

    Counting blank cells

    I want to count the number of non-blank cells in a column, the only issue is that if the adjecent columns are also non-blank then I want the contribution to be a fraction depending on the number of columns. I can use counta to give the total number on non-blank cells in a row that can then be...
  12. N

    Dynamic Range Issue

    Hi, I have a page at the beginning of my workbook that provides summary data on the rest of the 11 worksheets. For each of the 11 worksheets, I'd want to put the number of rows in the worksheet (# of rows minus 1 for the header would be even better). I'm running a macro that automatically...
  13. S

    N00b needs help counting :(

    I want to count each of the events in a session of "Baseball," a sweet drinkikng game. Goals: 1. be able to count occurrences of "s" for each batter. Tried: =SUM((C3:C14=”bruce”)*(D3:J14=”s″)) And got: #value! 2. do the same thing with three criteria -inning in column "a" -team in column "b"...
  14. R

    Help with counting across rows

    Good morning, I am in need of help with counting across columns. Here is an example table of what I would be looking at. <TABLE style="WIDTH: 542pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=720><COLGROUP><COL style="WIDTH: 31pt; mso-width-source: userset...
  15. P

    how can I count the amount of cells with a letter in it, whilst only counting ones from a title on the left column

    France A France A USA A Russia Canada A France how can I count the amount of cells with a letter in it, whilst only counting ones from France on the left column. I can get it to count the total amount which would be 4 columns with letters in but I can't get it...
  16. pedie

    How can my vba count number of rows copied?

    Hi, how can my vba count number of rows copied? i want the msgbox to show the # counts after the whole thing is copied. Thanks Pedie x = 1 y = 65500 c = 12 Application.ScreenUpdating = False With Sheets("Sheet1") For chk = x To y If .Cells(chk, c).Value = "X" Then...
  17. A

    SUM,COUNTA - Data Validation

    Hello all :) I've a problem .. I'm not sure if there's a solution let's assume that I have 5 cells (A1-A5) and in cell (A6) I used (SUM) equation to sum total value in (A1-A5) =SUM(A1:A5)in cell (B6) I have a (COUNTA) function .. to count cells which contain any entered value in a range of...
  18. H

    define names using COUNTA

    Hey guys, first of all thanks for the support during the whole time, i used this forum quite regularly I finally signed up because I cannot figure out how to solve a (hopefully) minor problem. I am using VBA to automatically create a bunch of defined names on a help! sheet in order to...
  19. H

    Help with COUNTA formula

    Hello Working in excel 2007 and I am trying to use "COUNTA" to count how many "TRUE"'s I have in a range. This is what I have but it's not working. What am I missing? =COUNTA(C10:K10) Any help or suggestions will be greatly appreciated. HDfatboy03
  20. R

    Counta / Countif Problem - PLEASE HELP

    I have manual entry cells A80:A90. I am trying to write a formula that says if all of the cells are blank, then the value in A91 is blank -- if however there are "Yes" values in cells A80:A90, the take the total number of "Yes"*500. In other words, they get $500 for each "Yes." The formula I...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top