Excel help

[bikingdad90]

As a capital accountant I use some advanced excel formulas as most of my spreadsheets 50 columns long and 34,000 lines long and link to a huge database.

Sumifs are the work of the devil-unstable and stop updating for no apparent reason so you end up deleting them and reentering.

At least I can get circular references to calculate properly but still do not understand when you reference in other formula you need to do it twice to get it work properly and not show 0 (even though 0+0 can equal 1000 when highlighted)

 

[Crackle]

General rule...if it's awesome it's London.

Drive=sumif(M25, not gridlocked)[between 'Dartford' and 'Potters Bar'])

 

[Markymark]

Drive=sumif(M25, not gridlocked)[between 'Dartford' and 'Potters Bar'])

Awesomeness = (1/(distance_from_London))*iphone_model_number

 

[Crackle]

Awesomeness = (1/(distance_from_London))*iphone_model_number

I bet you checked that to make sure you had it right.