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 reply

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