help with formula based on criteria

[kypok999]

Hi Guys,

I have criteria in A:AA so for example from A2 to A12 its the same text/criteria I need to sum CF based on: If CC has "Bet" then sum 419130.572916666666667Salisbury in this case =5.39 but if the number is -1 next to "BET" then like in next case 419130.583333333333333Newcastle must be -1 basically so i can calculate net instead of having -1 next to columns that i currently have..

https://imgur.com/a/oRG2t

 

[dnorm]

=SUMIFS(CF:CF,CC:CC,"Bet")

That will calculate only rows containing "Bet" and ignoring "NoBet" cells.
you can add A:A,419130.583333333333333Newcastle, on the end if you only want Newcastle for instance.
so it would become:

=SUMIFS(CF:CF,CC:CC,"Bet",A:A,419130.583333333333333Newcastle) would only calculate any row containing that Newcastle reference and have a "Bet".

I hope this helps.