counting

  1. S

    Counting coloured cells that are blank

    Hi I have a spreadsheet that has different colours in. I need to be able to count all blank orange cells within a certain range. Countblank doesn't work, so I thought of perhaps using countccolor as I can get it to count all the orange cells but then I don't know what to add to it to count...
  2. N

    Counting just months and yer in a range

    I am looking to count the number of times the month and years recur in a column. So, if it is FEB 19 and it shows up 19 times I would like to count that number of times. Is there any possible way for me to make this happen, Thank you in advance
  3. A

    count formula 3s&1s

    hi to all, i have an arrey formula at H1 which counts 3s and 1s only from a row G:G(random generator of 3s,2s,1s) and in case of number 2 apeared should count 0 and then continue counting 3s and 1s. the formula is working until 2 apears ,it shows 0zero but it stops, imean the zero is...
  4. J

    How many hours between 2 times including dates

    Good Morning, In cell A2 i am putting 10/01/19 12:00 in cell G2 i am putting 12/01/19 16:00. I am wanting to work out the difference between these 2 times. But the catch is i dont want the hours counting between 16:00 and 08:00 and also weekends/bank holidays if possible. At the minute i...
  5. T

    Find Consecutive months without counting empty cell in the middle

    <tbody> A B C D E F G H 1 1803M 1804M 1805M 1806M 1807M 1808M 1809M Remarks 2 1 1 1 1 First Month 3 1 1 1 1 2 Consecutive months 4 1 1 1 1 1 3 Consecutive months 5 1 1 1 1 4 Consecutive months 6 1 1 1 1 1 1 5 Consecutive months </tbody> Is there a way to count a...
  6. W

    Counting names in Numbers

    Hi I’d like to count the names I am entering in column B so I can see at a glance how many times the name appears. Can’t figure out how to do this. Thank you for any help. Regards
  7. D

    Counting using criteria in different columns

    Hello MrExcel Members Could you please help me with this. I have a database in which: Column E contains place names, ie: London, Cardiff, etc Column G contains abbreviated departmental names, ie: EM, FEE, etc Column P contains a number, ie: 1.0 or 0.4 or 0.6 etc At the moment, I create a...
  8. A

    Counting any cell containing either all, one or a subset of, a list of words

    Hi All, Forgive me for the following text explanation but we are blocked from uploading items at work and I’m at work at present. I have a basic table for recording health and safety, currently spanning A1 to N46. Column C contains words that relate to the type of health and safety issue...
  9. A

    Specific range date on a code with counting subjects

    Hi I have a code with counting specific subjects emails from outlook and copy to excel. I need to copy the same specific subject emails but with specific date range for example before 7 days I would appreciate any help Thank you
  10. P

    Counting groups

    I need to count the occurrences of groups of symbols in a column as follows: <tbody> Symbols X O O X X X O X O X X X X O X X X X X O Groups Occurrences O 1 2 0 1 OO 0 0 1 0 OOO 0 0 0 0 OOOO 0 0 0 0 X 0 1 0 0 XX 2 1 0 0 XXX 0 0 1 0 XXXX 0 0 0 1 </tbody>...
  11. Z

    Counting frequency of dates based on difference between 2 dates

    Hi, everyone. Can anybody help me with the formula for counting frequency of dates based on difference between 2 dates? Here's an example of what I am trying to do: ColA ColB Freq of <3 days Freq of >5 days Row1 09/30/18 10/20/18 Row2 09/30/18...
  12. G

    Counting the Most Recent Consecutive Values

    G'day Everyone, I hope you can help me with a counting issue. I have a spreadsheet that tracks project status changes that's updated weekly. Every week project managers show their overall project status using a RAG status. The colours correspond to numbers as below. Green Amber Red I want...
  13. T

    Sumproduct ?

    Hi I have a column of dates which cover several years in the format 01/01/2018, this column is modified with dates added to and removed regularly. I wish to be able to search for a particular year and then sum all the dates in that year without counting the same date twice. I have been trying...
  14. F

    Counting with 2 criteria up and down

    <tbody> Site Product UOM Product ID ID Value Sale Counter Results A Pen 9 26525802 77587241 1 2 1 A Pencil 9 <tbody> 32266576 </tbody> <tbody> 77586563 </tbody> 2 3 2 A Pen 9 47163111 77595902 3 4 A Sharpie 9 49726635 77592873 1 8 3 B Pen 9 26525802 77583416 8 9 1 B...
  15. L

    Counting Consecutive numbers > 100 in a column by multiple criteria

    Need help counting consecutive numbers > 100 in a column by multiple criteria. The criteria: Column A = Data!E$2 Column C = Data!E$3 Column D > 100 =MAX(FREQUENCY(IF(TMBYTM1!D:D>=100,ROW(TMBYTM1!D:D)),IF(TMBYTM1!D:D<>"",IF(TMBYTM1!D:D<100,ROW(TMBYTM1!D:D))))) the above works but only for...
  16. L

    Possible COUNTIF question across 12 Tabs

    Hi. I have been having a browse for an answer to this question, but my solutions aren't working. I have 12 tabs with figures, & a 13th tab with totals & average. The calculation for the total is below, but I would like a 2nd box to give me an average across the same 12 figures but only counting...
  17. S

    Sumproduct issue (counting blank cells)

    Greetings all! First Time poster, I am having an issue with a SUMPRODUCT formula to where the the outcome is counting all the blank cells. I have read through many posts about adding the same range with a (,<>"") at the end and it only produces a #VALUE error as a result. Below is my formula...
  18. D

    Counting number of times a number will appear in a Pasted column, some cells having multiple numbers in them using VBA

    For example I would paste in A1: 995 950-993 *995-118 118 790-118 I want it to return on a separate sheet: 995 2 950 1 993 1 118 3 790 1 Right now I have it coming back as exactly what is pasted in the cell and cannot figure it out what so ever.:confused: Thank you for your...
  19. J

    counting

    Can anyone help me with this? I have a Textbox and a List box with a delete button so i can remove the last row. In my listbox there are 2 columns (1st names and 2nd prices). My textbox counts the second row (prices). The delete button is doing it but does not counts down in my textbox. Can...
  20. S

    Countif problem

    Hi! I'm having a problem, probably a silly one but it's important for me and i can't figure it out. In my excel sheet i'm putting a countif with the range being a whole column, the problem is that in that same colum is also located the countif formulae. That is causing it to stop counting...

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