ongoing

Hi, Please see below an example of what I am trying to solve: I'm trying to return the sum of all numbers in columns C, D & E but only where column B is "Ongoing". As you can see, the answer should be 2165 but using the following formula only gives the result of 560: =SUMIF(B:B, "Ongoing"...

hi guys, New to the forum. However been referring to this forum from general google searches for years now. Seems today im at an impasse for a new problems which is quite specific. I've no doubt heads will be scratching. I need to be a manner in which I can determine the number of concurrent...

I don't do much with VB and need some help to count/tally up the number of instances of a given value. Data is sorted by the value so all results are together just need a ongoing count till value changes or cell is blank Value, Expected Result 23589, 1 23589, 2 23589, 3 23599, 1 23599, 2

Hello: I add a date say 3/2/18 in Cell A1. In cell A2 I want that cell to be a ongoing counter of calendar days from date 3/2/18. Is there a formula I can use?

Hello Everyone, Using Windows 10 on a newer surface. Have a .xlsm file that's about 14,000 KB. Literally crashes when i try to do anything.. convert whole row of data to number, calculate formulas, etc. When i google this seems to be a huge ongoing issue and seems to have the same message...

Hi guys, I am trying to come up with a macro that will automatically average the data in M3 from all the sheets and place the answer in N3. And I am trying to get a macro that will do this automatically when I create a new sheet. Right now I am tracking the weekly average of employee hours...

So, what I am trying to do is enter in a random number "X" in a column, and from that day forward it will increase by one number by each day (if i input 13 in today, tomorrow i pull up the excell sheet and it will show 14). So I'm into investing and I have come across a study that keeps tracks...