Sumif

[Guest]

I seem to always run into sumif problems with it not completing including all
numbers. I have a sheet that shows fuel as litres of gas for different
users. I have gas or diesel as an entry in one column and the litres in
another. I have asked it to sumif(a:a,=b50,e:e) just an example. All I get
is the last number in e that relates to B50 not a sum of all items in that
column that relate to e, what can I be doing wrong. Thanks

 

[Ragdyer]

Try this:

=Sumif(A:A,B50,E:E)

 

[Guest]

Thank you, worked like a dream, I obviously have been using areas instead of
columns.