nich wrote:
Hi I am trying to create a formula but having trouble the answer i want is

=sum of coulmn C if column A = "" and if cloumn B begins with ""

Please help kind hearted souls!!!

Here is an example:

A B C
1 m bays 564
2 n bat 264
3 m bayo 223

sum C if a=m and b begins with bay

i.e in this case c1 plus c 3