| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying and pasting with SUMIF and COUNTIF
I have a workbook with several sheets. One sheet serves as a 'dashboard' and
includes several SUMIF and COUNTIF formulas that reference cells on another sheet. The other sheet contains information that is exported from a database and pasted into the sheet on a regular basis. However, upon doing this, each cell on the "dashboard" that contains a SUMIF or COUNTIF formula returns a #REF! error message. Is there a way to change this so that I can keep the SUMIF and COUNTIF formulas and still be able to paste new info into the other sheet? Help please! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying and Pasting | Excel Discussion (Misc queries) | |||
| Copying and pasting | Excel Discussion (Misc queries) | |||
| Copying and Pasting | Excel Discussion (Misc queries) | |||
| Copying and pasting ??? | Excel Discussion (Misc queries) | |||
| Copying and Pasting | Excel Discussion (Misc queries) | |||
Threaded Mode
