Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Count If Formula Not Working - Help!
16 views
Skip to first unread message
SHEFFCOURT
Jun 5, 2013, 3:07:38 PM6/5/13
to
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
lhki...@comcast.net
Jun 5, 2013, 4:17:10 PM6/5/13
to
=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
Jun 7, 2013, 11:00:38 AM6/7/13
to
lhki...@comcast.net;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-
> 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
Howard,
> 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
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
lhki...@comcast.net
Jun 7, 2013, 12:53:08 PM6/7/13
to
Regards,
Howard
0 new messages