Excel: help with an =IF formula


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


This question generated 29 answers. To proceed to the answers, click here.

This thread is current as of July 11, 2014.


For more resources for Microsoft Excel