Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count If Formula Not Working - Help!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count if equal to not working? | Excel Worksheet Functions | |||
Getting Count Formula Working if Column has both number and text | Excel Worksheet Functions | |||
How can I count the working day | Excel Discussion (Misc queries) | |||
Formula to count distinct values not working in VBA | Excel Programming | |||
Count is not working | New Users to Excel |