Trying to add a division to a formula

Do you remember bodmas (podmas outside of the UK) from your school days? 2 missing brackets make all the difference
=(COUNTIFS(ALL!$I:$I,"W",ALL!$H:$H,"League",ALL!$L:$L,$D$11)*3+COUNTIFS(ALL!$I:$I,"D",ALL!$H:$H,"League",ALL!$L:$L,$D$11))/E11

I don't remember "bodmas" - what's that?

Pete

Thanks Jason. I guessed it was brackets but wouldn't have known I needed an extra one at the start. Much obliged.

Ps: I've never heard of "bodmas" either.

I'm not much the wiser …

Pete

So, if you dont mind, why is the first bracket added and placed where it is please?

Originally Posted by Glenn Kennedy

Jason showed you the position of the two additional brackets in RED in his post. It makes the formula execute the full formula before the division. Without them only the second countifs is subject to division.

Yes, saw that an added appropriately. I just wanted to understand why they were where they were. I think I've got it now now. Thanks.

You said that the original formula gave the correct result, so enclosing the whole thing in one pair of brackets means that the original formula is recalculated before the division is carried out.

Wthout the brackets, you were getting

COUNTIFS(ALL!$I:$I,"W",ALL!$H:$H,"League",ALL!$L:$L,$D$11)*3

COUNTIFS(ALL!$I:$I,"D",ALL!$H:$H,"League",ALL!$L:$L,$D$11)/E11

added together, the division was done before the addition.

The only other place that the opening bracket could have gone would be *(3+Countifs which would have also given an incorrect result due to the order in which it would calculate.

Maybe bodmas was called something else at different points in time, I had never heard of 'the bus stop method' until recently (google it).

Our school wasn't very strong on mnemonics …

Pete