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)