Comments on: Excel COUNT and COUNTA functions to count cells

Comments page 2. Total comments: 51

1. 

   LouieUSA says:
   2017-01-18 at 10:49 pm

   Hello I am trying to find a formula which allows me to add 2 different words in 2 different columns with drop down menus in each. Here are an example of the words:

   "A" for Column E

   For Column G
   ACV, AMV, FIRE, PER INJ, OTHER, PMV2, PMV4, PMVO, PRO DMG, SUPLMT, WATER, WPN/ND, AV GND

   A certain combination will only work for a specific column. Example:
   Accident Class:
   A
   B
   C
   D
   E
   F
   OHR
   NR
   Each of these only work with one word at a time, but all of the combinations for "A" need to be tracked in a column (A3) for example.
   "B" would tracked in A4 and "C" would be tracked in A5 and so on. If B and ACV were in their respective columns (Say E5 and G5)on one sheet, then those 2 numbers would be tracked on another sheet on A3 as a number.

   I hope this explains it well enough, thank you.

   1. 

      LouieUSA says:
      2017-01-23 at 9:52 pm

      I found the solution, disregard, thank you.

2. 

   DEBIPRASAD says:
   2016-11-20 at 1:58 pm

   HOW TO COUNT, I HAVE DATA OF STUDENTS FROM VARIOUS STATES, I WANT TO COUNT HOW MANY STUDENTS ARE FROM DELHI AND THERE SURNAME IS "REDDY" ? PLZ HELP

   1. 

      raghul says:
      2017-03-13 at 5:46 am

      =COUNTIFS(G2:G11,"****reddy",H2:H11,"delhi")

3. 

   Rohan Walimbe says:
   2016-04-06 at 12:01 pm

   can u send me a drop down list examples in excel where there is huge data for e.g

   Divison Zone Region Area HQ
   Divan West Mumbai Mumbai Mumbai
   Divan West Mumbai Mumbai Goa
   Divan West Pune Pune Pune
   Divan West Pune Pune Pimpri
   Divan West Ahmdabd Rajkot Rajkot
   Siman North Delhi dELHI Delhi
   Siman North Delhi jAIPUR Kota
   Siman North Delhi Jaipur Jodhpur

   This list is huge. Please help how to prepare drop down list

   if we click on Division the Divison will show then after clicking on Zone the zone and clicking on the specific zone the zones area will reflect with HQ automatically.

   Please help.

   1. 

      Svetlana Cheusheva says:
      2016-04-07 at 10:11 am

      Hi Rohan,

      Please check out the following tutorials:

      How to create an Excel drop down list: static, dynamic, from another workbook
      How to make a cascading (dependent) drop down list in Excel

4. 

   rinju says:
   2016-03-30 at 2:23 pm

   how can we use "if" function when there is either text or number in cell..

   if the cell contain text then answer should be "Yes" or else the cell contain number then answer shold come "No"

   1. 

      BADER says:
      2018-11-01 at 6:11 am

      Please reply

      CUSTOMER1(CONTAINER1) AVAILABLE
      CUSTOMER2(CONTAINER1) AVAILABLE
      CUSTOMER1(CONTAINER2) AVAILABLE
      CUSTOMER2(CONTAINER2) AVAILABEL

      ANSWER SHOULD BE CUSTOMER1 2

   2. 

      Svetlana Cheusheva says:
      2016-03-30 at 2:37 pm

      Hello Rinju,

      You can use a formula similar to this:

      =IF(ISTEXT(A1), "Yes", IF(ISNUMBER(A1), "No", ""))

      Additionally, you can check for blank cells:

      =IF(ISTEXT(A1),"yes", IF(ISNUMBER(A1),"no", IF(ISBLANK(A1),"blank","")))