Microsoft is evil…

It is official – Microsofts sole purpose is to make life as hard for us all as it can possibly be. You see I have been using Excel all day, and the functions SUMIF and COUNTIF have been very useful. They have allowed me to sum or count selected variables in two colomns based on whether the variables in one colomn meet a certain criteria. Well, I just went to use PRODUCTIF… Well not only does PRODUCTIF not exist (meaning that I will have to type =SUM(IF(Sheet1!A1>0,(Sheet1!A1*B1),0),(IF(Sheet1!A2>0),(Sheet1!A2*B2),0),(IF(Sheet1!A3>0),(Sheet1!A3*B3),0)… etc all the way up to…. (IF(Sheet1!A104>0,(Sheet1!A104*B104)), But it also crashed excel making me loose the last 3/4 hours work.

Grrrr!