Sum Cells
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Sum Cells as PDF for free.
More details
- Words: 260
- Pages: 13
20 50 60 50 180
20 50 60 50 Err:508
20 50 60 50
10 20 50 60
15 30 40 10
file:///var/www/apps/pdfcoke/pdfcoke/tmp/scratch8/9151928.xls
10/17/2008
Item Pen Pencil Binder Pen Pen Binder Pencil Binder Pen 37
Qty 5 9 9 6 15 12 10 6 11
Item
Qty
Pen Pencil Binder Pen Gel Pen Binder Pencil Binder Pen 0 0
5 9 9 6 12 12 10 6 11
pen
<==enter a text string in the yellow cell, e.g. "pen"
City Toronto Ottawa Hamilton London Kingston Guelph Waterloo Oshawa Milton 183
Reps
Qty 25 15 9 6 10 3 7 6 2
60 94 64 38 29 57 4 29 77
Status Active Hold Active Active Hold
Visits 4 15 10 18 9
Total Active with Visits >=10 325
Amt 100 250 125 200 180
20 50 60 50 20 30 70
#NAME?
251 747 847 713 45 561 309
198 854 437 663 112 462 322 905 251 117 194 726 147 6 512 776 477 54
Err:502
This is an array formula (Ctrl+Shift+Enter) To enter, hold the Ctrl and Shift keys, and press the Enter key
press the Enter key
251 747 847 713 45 561 309
198 854 437 663 112 462 322 905 251 117 194 726 147 6 512 776 477 54
Err:502
11
<==Enter the top X number here
This is an array formula (Ctrl+Shift+Enter) To enter, hold the Ctrl and Shift keys, and press the Enter key
p X number here
press the Enter key
Item Binders Binders Binders
Units 33 5 28
243
20 50 60 50 Err:508
20 50 60 50
10 20 50 60
15 30 40 10
file:///var/www/apps/pdfcoke/pdfcoke/tmp/scratch8/9151928.xls
10/17/2008
Item Pen Pencil Binder Pen Pen Binder Pencil Binder Pen 37
Qty 5 9 9 6 15 12 10 6 11
Item
Qty
Pen Pencil Binder Pen Gel Pen Binder Pencil Binder Pen 0 0
5 9 9 6 12 12 10 6 11
pen
<==enter a text string in the yellow cell, e.g. "pen"
City Toronto Ottawa Hamilton London Kingston Guelph Waterloo Oshawa Milton 183
Reps
Qty 25 15 9 6 10 3 7 6 2
60 94 64 38 29 57 4 29 77
Status Active Hold Active Active Hold
Visits 4 15 10 18 9
Total Active with Visits >=10 325
Amt 100 250 125 200 180
20 50 60 50 20 30 70
#NAME?
251 747 847 713 45 561 309
198 854 437 663 112 462 322 905 251 117 194 726 147 6 512 776 477 54
Err:502
This is an array formula (Ctrl+Shift+Enter) To enter, hold the Ctrl and Shift keys, and press the Enter key
press the Enter key
251 747 847 713 45 561 309
198 854 437 663 112 462 322 905 251 117 194 726 147 6 512 776 477 54
Err:502
11
<==Enter the top X number here
This is an array formula (Ctrl+Shift+Enter) To enter, hold the Ctrl and Shift keys, and press the Enter key
p X number here
press the Enter key
Item Binders Binders Binders
Units 33 5 28
243
