Count If Formula Not Working - Help!
 

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.

Count If Formula Not Working - Help!
 

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.

Count If Formula Not Working - Help!
 

On Friday, June 7, 2013 8:00:38 AM UTC-7, SHEFFCOURT wrote:
;1612159 Wrote:

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.





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

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







--

SHEFFCOURT

You are welcome, thanks for the feed back.

Regards,
Howard