OK
Please don't think this is a stupid question, but are there certain areas in the formula that are meant as references

Like somewhere should i say "Start at row 5 and work down"? "Sheet 1" - is this the name of the sheet where the macro does its work ie "Totals"? The IF Application line is giving me back an error "Expected Then or GoTo". When i enter "Then" i get another Expected: line # or end of statment. So when you use things like "Range" and Cells" is that literal content or am i expected to enter some argument

This is probably why i always have problems, i just don't have the knowledge to know why what is where, and therefore get stuck

Bryan