Sumif and begins with
=SUMPRODUCT(--(A1:A3="m"),--(LEFT(B1:B3,3)="bay"),C1:C3)
Regards,
Stefi
€žnich€ť ezt Ă*rta:
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
|