Quote:
Originally Posted by
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
|
Howard,
You are awesome! I knew it was something small but I could not figure it out! Thank you so much for your help! I will mark as solved once I revise my spreadsheet.