A few days ago, Jonmo1 helped me with the INDIRECT function, which has been great. I have used the INDIRECT function quite a bit on the workbook I am creating, however, I am having difficulty with one of them and was hoping someone could help. Here is what I have (I'm thinking that I'm not grouping/closing the parentheses correctly):
{=SUM(IF((INDIRECT("GLAccountNumber"&$A$1&"Class"=$A24))*(INDIRECT("GLClassNumber"&$A$1&"Class"=MID(G$3,6,4))),(INDIRECT("GLAccountBalance"&$A$1&"Class",""))))}
{=SUM(IF((INDIRECT("GLAccountNumber"&$A$1&"Class"=$A24))*(INDIRECT("GLClassNumber"&$A$1&"Class"=MID(G$3,6,4))),(INDIRECT("GLAccountBalance"&$A$1&"Class",""))))}