I have a spreadsheet that I copy a new worksheet with additional info each
week. I need certain info that has multiple criteria to add to one of the
"permanent" worksheets.

For example:

A B C
IRS IRSA 20.00
IRP IRP 20.00
IRS IRSA 20.00

On my Perm worksheet I have a column that is IRS/IRSA and I need to add
colum c1 and c3 to that number to get an ongoing total. what would be the
most effective way to do this?