Hi everyone,
I have a formula that calculates totals based on specific text entered in another cell, which works fine:
=SUMIF(D6:D28,"=*pine*",E6:E28)
This formula is entered into cell E32. What I would like is for it to look at the contents of D32, and alter its' search criteria accordingly.
Something like,
=IF(D32,"*pine*")=SUMIF(D6:D28,"=*pine*",E6:E28)=IF(D32,"*Larch*")=SUMIF(D6:D28,"=*lar*",E6:E28)
etc etc.
I feel like I'm close to getting this right but I don't have enough knowledge to be able crack it.
Any help would be much appreciated.
Cheers
Jon
I have a formula that calculates totals based on specific text entered in another cell, which works fine:
=SUMIF(D6:D28,"=*pine*",E6:E28)
This formula is entered into cell E32. What I would like is for it to look at the contents of D32, and alter its' search criteria accordingly.
Something like,
=IF(D32,"*pine*")=SUMIF(D6:D28,"=*pine*",E6:E28)=IF(D32,"*Larch*")=SUMIF(D6:D28,"=*lar*",E6:E28)
etc etc.
I feel like I'm close to getting this right but I don't have enough knowledge to be able crack it.
Any help would be much appreciated.
Cheers
Jon