On Wednesday, June 5, 2013 12:07:38 PM UTC-7, SHEFFCOURT wrote:
I have a formula that needs tweaking. In the formula in column I is not

calculating correctly. I need HELP! Can you guys fix this formula for

me?



I used the customer ADPRO for my example. If you look at their 2011

sales, they total: $61,944. But the formula is calculating it to sum

to $433,984.72.





+-------------------------------------------------------------------+

|Filename: ARCUSTSALESHISTORY_FORUMHELP.zip |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=881|

+-------------------------------------------------------------------+







--

SHEFFCOURT

In H2 I changed the formula to refer to E column instead of G. It returns the 61,944.03 you mention.

=IF(COUNTIF($A$2:$A3,$A3)=1,SUMPRODUCT(($A$2:$A$10 559=$A3)*($D$2:$D$10559=H$1),$G$2:$G$10559),"")

Regards,
Howard