Do you need to create a spreadsheet that will calculate a range of cells according to certain criteria? In addition, if you want to see something else in the cell to what you type in it that perhaps ...

I keep running into situations in Excel where I want to calculate a conditional sum, but my criterion is something along the lines of "Include cell B1 if cell A1 is a number, likewise B2 and A2, B3 ...

The tilde isn't the only sign you need to understand to truly get your head around Excel's inner workings. For example, the at (@) sign returns a single row value instead of spilling an array, the ...