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