![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
Hi and welcome please post a sample sheet. Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
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. |
![]() |
|