| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF - my formula misreads after data has been sorted
I am using a =sumif formula that is reading information from a source sheet.
So, if I insert a line on row 64 it calculates that if the information in the range onthe source sheet matches that in cell a on the worksheet, then it should take the figure from the source sheet that it matches. This works but then if I sort my data on the work sheet so that the information inserted into row 64 moves to say row 33 (where it goes alphabetically) the formula continues to read the information on row 64 ... why does this happen and how can I stop it happening? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF - my formula misreads after data has been sorted
Change to absolute references; e,g not A5 but $A$5
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Poodles" wrote in message ... I am using a =sumif formula that is reading information from a source sheet. So, if I insert a line on row 64 it calculates that if the information in the range onthe source sheet matches that in cell a on the worksheet, then it should take the figure from the source sheet that it matches. This works but then if I sort my data on the work sheet so that the information inserted into row 64 moves to say row 33 (where it goes alphabetically) the formula continues to read the information on row 64 ... why does this happen and how can I stop it happening? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF - my formula misreads after data has been sorted
What does your formula look like before and after the sort?
"Poodles" wrote: I am using a =sumif formula that is reading information from a source sheet. So, if I insert a line on row 64 it calculates that if the information in the range onthe source sheet matches that in cell a on the worksheet, then it should take the figure from the source sheet that it matches. This works but then if I sort my data on the work sheet so that the information inserted into row 64 moves to say row 33 (where it goes alphabetically) the formula continues to read the information on row 64 ... why does this happen and how can I stop it happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dependant Data Validation not sorted | Excel Worksheet Functions | |||
| How do I insert rows between sorted data | Excel Discussion (Misc queries) | |||
| Trying to have data from one sheet to another sorted.... | Excel Discussion (Misc queries) | |||
| Print sorted data | Excel Discussion (Misc queries) | |||
| Lookup thinks data isn't sorted | Excel Worksheet Functions | |||
Linear Mode
