Multiple Sheets with Data

Closed
Niki - Jul 16, 2009 at 11:18 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 17, 2009 at 01:32 AM
Hi I have a spreadsheet with 8 clients listed on 8 rows. There are 9 coulmns of information. I have the following formula at the very bottom of the sheet (=SUMIF($D$5:$D$96,I113,$C$5:$C$96). I want to be able to move this formula to a separate sheet kind of like a summary sheet and have information from multiple sheets "drop in" here. I hope that makes sense.

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 17, 2009 at 01:32 AM
Hello Niki

Just CUT and paste to your destination dont copy and paste
0