Problem with Formula of IF/AND/COUNT/SUM

D

Dpocahontas

Hi All: I have this formula which calculates the target achievement fo
a month based on the Net Actual/Net Plan. The below formula has a goo
thing as it takes into consideration that even when the plan is negativ
(as there is this weird plan now with the crisis), but the net actual i
positive it calculates it as positive achievement
=IF(AND(COUNT(I79,I80)=2,I80<0),I81/I80,+I79/I80) Now the table is a
per below:


=IF(AND(COUNT(I79,I80)=2,I80<0),I81/I80,+I79/I80
=IF(AND(COUNT(I53,I54)=2,I54<0),I55/I54,+I53/I54) - this formula is use
for Monthly Target Achievement % while for the up to date targe
achievement % I use =SUM($C$79:I79)/SUM($C$80:I80) and it gives in Jul
realization -101.53% which is not correct according to my needs. Now yo
help is , can I make the above formula = if(and(count(sum and make th
sum of months from January to July for each cell ....I try to do it bu
it gives an error of parenthesis and it or check your formula!! any hel
please! I hope is clear, sorry if not! but numbers are not so easy t
explain for me! thank yo

+-------------------------------------------------------------------
|Filename: Book2.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=545
+-------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top