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!