Not sure how the data jibes. You have four columns of data and your equation references A through F (i.e. six columns).

SUMIF takes the form SUMIF(range, criteria, [sum_range]). I am not sure what happens when you have a range for the criteria.

I'm not exactly sure what you want to do. What do you mean by "I want the grand total of those contained both in B and F". Do you want to sum column A for rows where B equals F? How would you get $551? No values in B equal the corresponding value in F. B are all 3xx and F are all 4xx. If I only sum those A where the last two digits in B and F are the same, I get $615.