count array

Can someone please fix this Google Sheet for me? I need it desperately for work. I cannot figure out what I'm doing wrong, and every formula I've looked up doesn't work for me. It's driving me CRAZY! o_O I've highlighted the columns that are giving me issues in yellow (sheet linked at bottom of...

I wasn't sure how to title this. This is for my NFL fantasy draft spreadsheet. I have a sheet that shows in order who has been drafted and what their position is. What I'd like to be able to do at a glance is see where a drafted person comes in order of the position. In other words, when...

Hi, I want to have a vba code to count any consecutive cells in each row with the sum of any arraylist values over 5 then underline those consecutive values. Sub highlightCells() Dim ws As Worksheet Set ws = ActiveSheet Dim lastrow As Long lastrow = Range("A2").End(xlDown).Row...

Hello everyone, I have a challenge that you might help me with. i Have a twofold challenge with my attached data set and i am looking for a formula to provide me the required insight. I need to count the number of months until a product reaches a rolling average value of 2 million. Can you...

10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated. See attached spreadsheet.... I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green) In row 71 and 72 (in yellow), I would like to...

Hi guys, I'm struggling with formula, which will count the number of operations "name" did simultaneously, even partially. I'd like to have a 1 or 0 information in new column (1 = the time interval exist, even partially, anywhere else). Data looks like this: <tbody> name start end Mark...

Hello. I'd like to figure out a formula in a single cell that returns an array of counts rather than an overall grand total count for a given list of columns. Example. If I have the following 3 columns and four rows: x x x x x x The answer I am...