Excel’s SUMIF formulae allows you to obtain the sum of a range of values that meet certain criteria. For example:
If we wanted to obtain the total number of Cars then we could use SUMIF:
=SUMIF(B5:B12,”Cars”,D5:D12)
and if we wanted to obtain the total vehicles in Cambridge we could use:
=SUMIF(A5:A12,”Cambridge”,D5:D12)
However what would we do if we wanted [...]
Imagine that we have the following data:
And we want to find the people with the highest 3 marks. Note for this example, we will assume that there are no two people with exactly the same score.
The function RANK allows us to do this. It needs 2 arguments – the cell that we are comparing [...]
Consider the following table of data:
If we want to find the total of all the Lorries then we could use the SUMIF function:
E25 = SUMIF(A5:A20,”Lorries”, E5:E20)
Like so:
And likewise we could total all the red vehicles:
=SUMIF(C5:C20,”Red”,E5:E20)
However what about if we wanted the total of all the YELLOw Vehicles in London ? There are in fact [...]
Kaps | 
09 5th, 2008| 
