Using sumif on different columns without getting a double/triple sum up

  • Hi guys!

    New as a user, but quite experienced as a reader of this forum, but I couldn't find an answer to my problem this time, so I had to register! :)


    Please pardon my english, it is indeed my second language, but I'll try my best.


    In the formula I've created using sumif and sumifs I want the amound from Column A to sum up, if in Column B we got a specific text and/or a reference number in column C.


    I've attached my file, where you can see the formula I'm using - but it counts double (and I understands why it counts double, I just don't know how to make Excel stop doing it)