Thread
:
Count If Formula Not Working - Help!
View Single Post
#
4
Posted to microsoft.public.excel.misc
[email protected]
external usenet poster
Posts: 168
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
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]