Forum Discussion
Excel formulas
Hi I am new to making spreadsheets on excel, i also have a mac and using the excel on my mac. I am trying to add how much we make for the type of treatment we provide. for instance we have ...
Hi Lundsie,
That could be like
=SUMPRODUCT((A1:A5={"OP","IOP","PHP"})*{375,1295,1595})
where instead of A1:A5 is your actual range with abbreviations