Sumif
 

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

Sumif
 

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Arlene" wrote in message
...
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

Sumif
 

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

"Ragdyer" wrote:

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Arlene" wrote in message
...
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