HOW DO I...!!??

Question

I trying to do some weird things to my workbook in excel but I really dont know how. I know that number 1 needs a VBA (which I would greatly appreciate whoever provides it). And im really not sure if number 2 is possible but if it is, PLEASE SHOW ME! I would greatly appreciate all the help and instructions. My questions are:

1.  I want to know how many inputs are put into my columns. I dont care about the values of the cells and/or columns, I just want to know the number of inputs that are in that column. Or to make it easier, how many cells are filled out in a certain column (while not caring about the values plugged into the cells).

For example (not exact columns or locations, just examples):  If I only put 100 in B8 and 250 in B200 (column B) it will show 2 in cell B1 (equation target). So it told me how many inputs are in column B.

I need the following function(^^^), but in these exact locations:

-I need to know how many inputs are in column AB. But I only want to know how many inputs are put in after cell AB8 and down (including AB), so everything from AB7 down (not including AB7). I want it to show me how many inputs there are in cell AB4. So thats where i want it to show me how many inputs there are in the column/cells I want.

-I need the same thing as ^^^ but on this one I want to know how many inputs there are in column AC8 and down (including AC8). And I want it to show me the number of inputs on the cells i want in cell AB3. 

                                                                    I NEED BOTH! (their the same function but for 2 different locations)

2. How can i put a chart from a certain website I want into my chart. But I literally want the table to work in the excel. As it is an interactive table which requires web connectivity. So basically I want it as an alternative to going to the website itself, while still having all the features.

I already tried... Data, From web... but it didn't allow it.

PLEASE HELP, i would greatly appreciate everyone to help and hope everything works. THANK YOU!

Answer 1

For #1, take a look at the COUNT, COUNTA, COUNTIF or COUNTIFS formulas. 

SOmeone else is going to have to help with 2.

Answer 2

For #1, take a look at the COUNT, COUNTA, COUNTIF or COUNTIFS formulas. 

 

SOmeone else is going to have to help with 2.  

Thank you for at least doing number 1. Really appreciate it!!