drag formula

  • Thread starter Thread starter Fiona
  • Start date Start date
F

Fiona

Does anyone know how to solve this problem I'm having.....

I type this sum in a cell =COUNTIF($A$18:$A$100, A3)
I then drag the formula down.

It only works in the other cells if I click in the cell (or F2) then out
again. It does not automatically work when dragged down.

Is this a formatting thing??

many thanks
 
Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel Dragging countif formula with changing criteria 3
Excel Excel help with drag and reference cell option 1
Excel Drag autofill only part of formula 3
Excel Copy COUNTIF while retaining reference 7
drag formula down from columns that go acros 3
Dragging a formula in a column 1
Locking a cell reference in a formula 1

Back
Top