This should help

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

"CC-Khriz" wrote in message
...
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!