Here are some problems that our users have asked and received explanations on
what does this mean in optimization =SUMPRODUCT(E$6:E$16,$K$6:$K$16)/E$21
Solved by A. L. in 19 mins
I need help sorting data. What I would like is the data in the 'TERM 1 LOA' table to automatically sort as follows: A+, A, A-, B+,B,B-,C+,C,C-,D+,D,D-,E+,E, E-,N without changing the formatting. Thank you
Solved by O. Q. in 21 mins
what does this mean: =query(Status!1:999,"select E , count(C) where (C <> '') group by E order by E label count(C) 'Count', E 'Stage' ", 3)
Solved by O. W. in 17 mins
What formula would I use if creating an IF/Then statement? I would like to total the amount if the corresponding box is checked. I.e. if cell E:7 is checked, then add E:6 to the total.
Solved by E. E. in 30 mins
I want this formula to give a value of zero if the word Roads appears in B10 (B10 is a pick list), but it only calculates the G10*$E$8. What am I doing wrong? =IF(PieceSize<>"*Roads*",G10*$E$8,0)