Yes....

In a blank cell, type =SUM(

Experiment with this:
Select one or more entire column(s) or row(s) and see how the formula
changes to reflect the selections.

Example: If you selected columns E through G, the formula will display:
=SUM(E:G


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Knot2Brite" wrote:

Hello,

I am working on an Excel course from OzGrid.

One of the problem/examples defines the MATCH function Array as 1:1. In my
ignorance I expected something like A1:G50.

I can't find in Help an explanation of what "1:1" defines. I will
appreciate some guidance.

Thanks

Bob