COUNTIF not working

[Rhiannon]

Please help, I have developed a database using excel for our team to capture our statistics. There are numerous drop down boxes that the team will make selections from and I would like to tally data from these selections. I have managed to use the COUNTIF formula (e.g: =COUNTIF("Q7:Q27,"*Quit because you can booklet*") to calculate specific data and these worked fine. Recently our team has suggested adding more columns to the excel worksheets and now my formulas are not working. Does anyone have any other suggestions on how I could fix the problem? I have attached a screen dump of the excel document and circled the area that I am having problems with. I have click the 'display formulas' button but the area circle there is no formula being display and this is not calculating my tally's.

thanks

 

[David Evans]

Rhiannon -

Post a copy of the file that contains the offending formula. Unfortunately a picture is not much use in fixing bugs

 

[Rhiannon]

ok David, I will try now. My issue is that the formula is not showing it is just showing the No. on the other tallies the countif formula is working but on the new additions I can't see the formula and I assume this is why it is not calculating right. I have attached the file. Thanks

 

[David Evans]

Put this formula in S39 -
=COUNTIF($Q$7:$Q$27,R39)

I think that's what you're trying to do here - count the number of times each of the values occurs in the range? If not, be specific about what answer you'd expect to see.

If you need to see which cells the formula is encountering, press F2 when you're in the cell and they will become color coded

I've attached a file with some formulas included under Tobacco resources - see if that makes sense to you.

Is it Friday in Australia? Oct 6th? If so I need to wish a friend of mine Happy Birthday

 

[Rhiannon]

Thank you so much David, I will have a go at the new formula. Yes its Friday and today is the 6th October, you better wish your friend a happy birthday. thanks again