Greetings

[ErickTru]

Good to be part of this forum. I will start with a problem I encountered when using SumIfs. This is the formula to be used:
=Sumif(B:B,F:F,A:A)
A B C D E F
$100.00 300 $100.00 400
$101.00 301 $101.00 401
$102.00 302 $102.00 402
$103.00 303 $103.00 403
$104.00 304 $104.00 404
$105.00 305 $105.00 405


$106.00 306 $106.00 301
$107.00 307 $107.00 305
$108.00 308 $108.00 310
$109.00 309 $109.00 315
$110.00 310 $110.00 320
$111.00 311 $111.00 406
$112.00 312 $112.00 407
$113.00 313 $113.00 408
$114.00 314 $114.00 409
$115.00 315 $115.00 410
$116.00 316 $116.00 411
$117.00 317 $117.00 412
$118.00 318 $118.00 413
$119.00 319 $119.00 414
$120.00 320 $120.00 415
As you can see, I want the grand total of those contained both in B and F. My result in this example should be $551.00 but the formula used does not work. Your feedback is greatly appreciated and thank you in advance fore your time.
Cheers,
ErickTru

[Pecoflyer]

Hi and welcome please post a sample sheet. Thx

[gebobs]

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.