need help with a simple xls equation !!

there is prob a very obvious answer but I need to use the "and" function with
the "sumif" function.

eg: 3 columns (a= account number b=product & c=value)
so:
sumif ( range=columns a:c ,criteria=(a="X" & b ="Y"), sum_range=c)

I need to use a single cell to calculate the equation?
Pls Hlp!

This should help

http://www.j-walk.com/ss/excel/tips/tip74.htm

"CC-Khriz" <CC-Khriz@discussions.microsoft.com> wrote in message
news:816BA50D-05FA-4E39-999B-EF65D5CD6DED@microsoft.com...
> there is prob a very obvious answer but I need to use the "and" function
with
> the "sumif" function.
>
> eg: 3 columns (a= account number b=product & c=value)
> so:
> sumif ( range=columns a:c ,criteria=(a="X" & b ="Y"), sum_range=c)
>
> I need to use a single cell to calculate the equation?
> Pls Hlp!

This should help

http://www.j-walk.com/ss/excel/tips/tip74.htm

"CC-Khriz" <CC-Khriz@discussions.microsoft.com> wrote in message
news:816BA50D-05FA-4E39-999B-EF65D5CD6DED@microsoft.com...
> there is prob a very obvious answer but I need to use the "and" function
with
> the "sumif" function.
>
> eg: 3 columns (a= account number b=product & c=value)
> so:
> sumif ( range=columns a:c ,criteria=(a="X" & b ="Y"), sum_range=c)
>
> I need to use a single cell to calculate the equation?
> Pls Hlp!

This should help

http://www.j-walk.com/ss/excel/tips/tip74.htm

"CC-Khriz" <CC-Khriz@discussions.microsoft.com> wrote in message
news:816BA50D-05FA-4E39-999B-EF65D5CD6DED@microsoft.com...
> there is prob a very obvious answer but I need to use the "and" function
with
> the "sumif" function.
>
> eg: 3 columns (a= account number b=product & c=value)
> so:
> sumif ( range=columns a:c ,criteria=(a="X" & b ="Y"), sum_range=c)
>
> I need to use a single cell to calculate the equation?
> Pls Hlp!