Thread: After sorting the formula has the incorrect cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tiq tiq is offline
external usenet poster
  
Posts: 6
Default After sorting the formula has the incorrect cell
I am using the following
=SUMIF(Taken!A$1:A$1999,Accrual!C6,Taken!D$1:D$199 9). When I do a sort on
the data the Accrual!C6 remains cell C6 but it should be C10 because I added
information and then sorted and the formula is now on line 10.

Can anybody help??
Reply With QuoteReply With Quote