G
Guest
Guest
Hello,
I am working on a calculator in excel using two seperate sheets. (data sheet and calcualtor) I cannot come up with a formula for the calculator to grab the info from the data sheet no matter what cell it is in and bring it into a calculator. I am trying to make this as dynamic as possible, so when I change anything in the data sheet the calculator will never miss a beat. I tried something like this:
=SUM(COUNTIF($D$5:$R$23,104)*_104p)+COUNTIF($D$5:$R$23,105)*_105p+COUNTIF($D$5:$R$23,107)*_107p
($D$5:$R$23,107) = This equals my calculator and if someone types 107 in, it references
*_107p which is the rename of the cell in the data sheet and what is in it. so lets say the type 107=56. They will see the 56 pop up on the calculator
The problem I am having is I get #NAME$, so this makes the calculator not work. I also have 113 different cells in the data sheet so as you can see it is one long formula, is there anyway to make this formula smaller and work. Thanks in advance for your help!
I am working on a calculator in excel using two seperate sheets. (data sheet and calcualtor) I cannot come up with a formula for the calculator to grab the info from the data sheet no matter what cell it is in and bring it into a calculator. I am trying to make this as dynamic as possible, so when I change anything in the data sheet the calculator will never miss a beat. I tried something like this:
=SUM(COUNTIF($D$5:$R$23,104)*_104p)+COUNTIF($D$5:$R$23,105)*_105p+COUNTIF($D$5:$R$23,107)*_107p
($D$5:$R$23,107) = This equals my calculator and if someone types 107 in, it references
*_107p which is the rename of the cell in the data sheet and what is in it. so lets say the type 107=56. They will see the 56 pop up on the calculator
The problem I am having is I get #NAME$, so this makes the calculator not work. I also have 113 different cells in the data sheet so as you can see it is one long formula, is there anyway to make this formula smaller and work. Thanks in advance for your help!