Count If Formula Not Working - Help!

[SHEFFCOURT]

I have a formula that needs tweaking. In the formula in column I is no
calculating correctly. I need HELP! Can you guys fix this formula fo
me?

I used the customer ADPRO for my example. If you look at their 201
sales, they total: $61,944. But the formula is calculating it to su
to $433,984.72

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

 

[lhkittle]

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|

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

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$10559=$A3)*($D$2:$D$10559=H$1),$G$2:$G$10559),"")

Regards,
Howard

 

[SHEFFCOURT]

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

=IF(COUNTIF($A$2:$A3,$A3)=1,SUMPRODUCT(($A$2:$A$10559=$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 figur
it out! Thank you so much for your help! I will mark as solved once
revise my spreadsheet

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

 

[lhkittle]

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.





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

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

You are welcome, thanks for the feed back.

Regards,
Howard