Countif and Sort

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

I have posted this before but never really got an answer
so any help would be really apreciated. When I sort data
in a spreadsheet countifs do not change to reflect where
they have moved to. For example, say I have a table of
data 5 rows by 5 columns and in D1 I have formula of
=COUNTIF(Sheet2!C:C,Sheet1!A1). I then copy this down to
the other rows altering the A1 part to A2,A3 etc. Now I
sort the spreadsheet and row 1 moves to row 4, however the
countif moves too and row D4 now reads =COUNTIF(Sheet2!
C:C,Sheet1!A1) but I want in to look for A4??? I have to
sort the countif row as I have data in E which needs to
move too. I'm sure this must be possible because if it
were a lookup such as =vlookup(A1,Sheet2!C:C,1,false) and
I sorted, it would then change to =vlookup(A4,Sheet2!
C:C,1,false)

This is really annoying me so please help - any more info
needed just let me know.

Cheers

Andy
 

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
countifs/or 2
COUNTIF with two conditions 2
Excel Moving data to sheet2 from sheet1 0
find text from 1 col in 2nd col & return value from 3rd col 3
Countif contains a word in a reference cell 3
Sorting and COUNTIF 6
COUNTIF greater than one column and less than another 5

Back
Top