Hi all,

I am trying to find a formula that will sum the values of two columns with the same heading (in my case the heading is "GST"). Every month this info changes, so the GST may not be in the same column all the time. I have around 1000 rows I need to sum. Example data below:

Amount GST Amount Total Card Fee GST Card Fee Total
100 10 110 50 5 55

Is there a formula when I can sum two columns based on the column NAME?

Thanks,
Audrey