Hi all,

I made a spreadsheet and it was perfect. However, silly user didn't see it
that way and removed a couple of columns she deemed unnecessary.

On another worksheet I had some summary data, including 12 rows representing
each month of the year, and two other columns. Each of these two columns
used sumproduct to test the data in two columns on the worksheet where the
user removed the columns. If various conditions were met in the
corresponding two columns for the column/row on the summary worksheet, a '1'
was assigned and then those were added up by month.