How to nest IF & SUM formula?

March 15, 2016 at 16:43:32
Specs: Windows 7

See More: How to nest IF & SUM formula?

#1
March 16, 2016 at 06:27:00

Report •

#2
March 16, 2016 at 08:54:06
 The answer would be yes to your final comment. This may help to keep it simple, what formula should be used to tell if cell y12 has an A, B or C in it for it to know which range to search for the resultHope this helpsmessage edited by Basecalc

Report •

#3
March 16, 2016 at 09:25:15

Report •

Related Solutions

#4
March 18, 2016 at 07:53:56
 Actually yes I can have it both ways as I want it.The answer to Instead of this:Why I calculated IF(AD12>2,AD12-2,IF(AD12<=2,AD12-AD12)) gives me the correct result: the difference from what is over the minus 2, 3 or 4 etc or else the result is zero and as I mentioned in the beginning "I've got most of this to work ezcept how to get Y12 to realize a,b or c"So I'l ask in a different way, what formula can I use in cell AA12 to choose the sum of which range from ad..:au.. or the other based on if cell Y12 has an a or b or c in it BCmessage edited by Basecalc

Report •

#5
March 18, 2016 at 09:52:42

Report •

#6
March 18, 2016 at 10:20:20

Report •

#7
March 18, 2016 at 19:43:43

Report •

#8
March 18, 2016 at 20:19:11
 I understand the protocol for not allowing direct communication, so be it, but at least you understand there's something being missed.I made a mistake to not revise/correct the end result to the calc in which that created a stumbling block on your side but was defined in the original question but to clarify first.IF Y12 Has A,B pr C then sum (determined range) so if it's A the range a4:b3. or B a3:f4, etc.

Report •

#9
March 18, 2016 at 20:37:32
 OK, now you have absolutely lost me.However, this time I mean it when I say that I will offer no more assistance until you answer my question about AD12-AD12. This is your third (and last) chance to explain to me why you aren't simply using 0.Answer that question, or at least acknowledge that you will use 0 instead of AD12-AD12 and then we can get back to your bigger issue.

Report •

#10
March 18, 2016 at 20:56:47
 Again I'll answer that question as I did Basecalc March 18, 2016 at 07:53:56, gives me the correct result: the difference from what is over/above the minus from the buffer of 2,3 or 4 which tells that no one did a mach-up with the original number I gave in the first question and with those results may have helped communications along with reading my answers, See ESC for golf as a comparison. So regardless of any other calculations it appears that your ways of thinking are limit if you continue to be stuck for an answer.

Report •

#11
March 18, 2016 at 21:37:39