“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to count values in a row that recur consecutively - the values are 1, 2 or 3 and I need to know how many times these numbers recur consecutively twice, three times, four times, five times or six times in each row. Is there a formula that can do this?
Thanks

Solved by D. D. in 30 mins

I am trying to count the amount of audits were run by type. One column says the date then one says the type of audit then the next says who was audited. What formula will allow me to count how many total audits there were since there multiple run on the same date.

Solved by O. L. in 19 mins

i want to count how many times something appears with a certain answer

Solved by G. J. in 30 mins

I need to be able to compute rolling averages with rows. I understand how to do it with columns. =AVERAGE(OFFSET(C7,COUNT(C:C)-G6,0,G6)) as the highlighted portion of the spreadsheet shows in sheet 1. I just need the formula to process this for rows. Highlighted in red.

Solved by I. J. in 12 mins

I want cell H5 to count every date is that is in June from B13:B102 . I have my helper 2 helper cells set with the date range starting at M5 and ending on O5. What is wrong with my formula??
=COUNTIFS($B$13:$B$102, ">="&$M$5,$B$13:$B$102,"<="&$O$5)

Solved by G. F. in 29 mins

I want to use countif based on a cell reference, but ALSO count if the range contains the criteria in parts of the cells.

Solved by C. E. in 26 mins

I need help with countif criteria. How do I get countif to count a single cell twice based on a criteria

Solved by G. J. in 19 mins

Trying to count how many instances of "1/2" is mentioned in a column. The formula I am trying is: =COUNTIF(E2:E19,"1/2"). The Function Argument box is calculating the correct amount, but the spreadsheet cell only shows the formula.

Solved by I. J. in 30 mins

Hi, I have two formula's I need help to build. Both of these are to give the count of each "namekey = 1" in column C on the style status tab.
1. TAB "Open to Buy" - Column D = The count of "name keys" [each namekey = 1] from column C - but only count -TAB Style Status - the "name keys" that have a qty in column U - W/H Qty and total count into each corrosponding categories, such as 01VES etc using the column D - style status tab & column A - open to buy tab.
2. Open to Buy TAB - Column O = By Categories 01VES as above - Count of "Namekeys" [namekey = 1 style] in Style Status Tab - column C but only if style status TAB - column Q date is in the date range of Open to buy TAB - K4 to K5
thanks

Solved by I. H. in 29 mins

Getting mismatched rows count when using =SUMPRODUCT in google chrome.

Solved by S. F. in 27 mins