Auto updates not working in Inputs

[sunplum]

Hello I have a spreadsheet with calls. In my inputs table I have a formula for each type of call to count how many are made. They are not auto updating. It is switched onto automatic but when a new call comes in, it is not counted in my inputs table.

my formula : =COUNTIF(Log!$J19:$J3947, Inputs!N3)

[dredwolf]

not sure if this is the problem, but it might be

=COUNTIF(Log!$J19:$J3947, Inputs!N3)
should (I believe) read
=COUNTIF('Log'!$J19:$J3947, 'Inputs'!N3)

hope that helps

-Edit- see revised formula, had the ' outside the brackets..

[sunplum]

Hello.
Thank you I tried to put the ' in and they just dissapear when I press enter. I guess this is obvious but in case it is not.In my J column each time I get a call I input what type of call it is in my spreadsheet.Thus it continues down the J cells, I am trying to get my formula to automatically include the new data.

Cheers.

[dredwolf]

I'm not sure why they would disappear, sounds odd to me, but you could just copy my example, and paste it into your worksheet...I don't see any reason why it would not work if your still having problems getting them into the cell(s)

[sunplum]

Thank you very much for your help. It is still not working I copy and pasted your example. It's got me.

[dredwolf]

could you upload a sample that is similiar to your real workbook (no private/confidential info though...just need so see what is actually happening to make some sense out of this.. )
should keep formatting for cells same and have the simulated data close enough to recreate the problem you are having..

Add a File - click advanced (next to quick post), scroll down until you see "manage file", click that and select "add files" (top right corner). click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

[sunplum]

Hello,.
So it wouldn't upload.
Its basically a drop down box of Type.

Fruit- Drop down list
Banana
Orange
Apple
Pear
Banana
Banana
Apple
Orange
Banana

then on a seperate page I have a table with the formula as above

[dredwolf]

Sorry, but without something solid to work on, my answers are meaningless...only reason I can see it not uploading is size, so cut out out whatever does NOT apply to the problem, change whatever is private/confidential to something similiarly formatted and try again...the limit (I think) is 1 megabyte

the answers I'm providing you with are not working, so i need something closer to your real spreadsheet to work with

data in a post is RARELY the same as it appears to Excel (formatting,actual values,etc..) change when we try to copy-post...
If this is not possible, I'll have to say I'm stumped, and hope someone else has some new idea(s)

[sunplum]

example.xls


hehe i made it small

[dredwolf]

LOL ! OKay...now I'mi even more confused...what is going wrong where.....can you hi-light the problem cells, and hopefully give me an idea of what they are supposed to look like??
Really, I'm not trying to be difficult, I just truly have no idea what you expect to see from the data given...maybe I should bow out to someone with more experience..

-Edit-
if this is only about the auto update, then the only thing I can see is that the formulas don't extend down any further...maybe that is the problem?

-Edit 2-
Actually, I think I figured out at least part of it...there is missing data in your table, so dependent calculations can not be made, hence, no update ? (ie columns A/B/C )

[sunplum]

Ok. that is ok.
On the first page I have Enquiries. I receive different types of enquirers. For each enquiry I log it as you can see.

On the second sheet (inputs) I have a table tallying the totals of the different enquries i receive. The formula is on each tally.

This formula is not auto-updating as I enter more enquirers into the first page. So the numbers stay the same, even when I get more enquiries.

[sunplum]

Dredwolf is this your job or are you just good at excel?

[dredwolf]

I'm a Carpenter by trade, a (old school, top down (not OOPS)) programmer by schooling, and I love the challenges of Excel
I can see your formulas, I just cannot see where your issues are..can you highlight the cells in LOG that are not showing up? (there's way too many for me to eyeball check them )

AND
By the way, as far as I know, NOBODY on this site gets paid for helping anyone, this is user's helping other users, no pay needed

[sunplum]

Great! I just got smashed with lots of work (im at work) but will upload them asap

[dredwolf]

Okay, it might be awhile before I can get back to you, as it is getting late here, but I will look at anything you post here..
But, hopefully, if I can't get you an answer, someone else here can...not abandoning you, just bowing down to reality of needed sleep

[sunplum]

example.xls

Highlighted areas.

[dredwolf]

well...based on what you have in the notes on sample, it is because your range only goes to 4677...no further... extend the range and it should continue to auto-update;
change the range to 50000 maybe...that should keep you auto updating untill you upgrade !

Hope this helps

[dredwolf]

i have also noticed some inconsistencies in the formulas on the Inputs page
ie ..
'D3' =COUNTIF(Log!$H$9:$H$50000, Inputs!C3)
'D4'' =COUNTIF(Log!$H20:$H$50000, Inputs!C4)
'D5' =COUNTIF(Log!$H21:$H$50000, Inputs!C5)

the first is an absolute reference to the start cell of the column H log data, while the others are not only not referencing the same data, they start 11 rows later ??? error or am i missing something ?

Edit

same data, but ignoring 10 rows of data
not sure, but seems to me your results will all be skewed by this ...

[sunplum]

Thank you sooo much dredwolf. I am forever in your excel debt.

After all that it seems like DUHHHH.
But I actually thought it was meant to auto update the cell range rather than the sum of the cells that I had already put into range. WOOHOO.

cheers mate.

[dredwolf]

Your Welcome