PC Review


Reply
Thread Tools Rate Thread

Counting cells only if cell X equals "yes"

 
 
Frustrated
Guest
Posts: n/a
 
      5th Nov 2009
I am tracking my sales reps sales. I currently have a formula to track that,
but now i need to track their sales only if they add a certian feature to the
sale. So now i need to find a formula that tracks their sales if they answer
yes to cell x. If they answer no to cell X i do not want to count that
sale. Can someone please help. The formula that tracks their individual
sales is COUNTIF($A$19:$A$3703, A10)
 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      5th Nov 2009
Please refrain from multiposting


=SUMPRODUCT(--($A$19:$A$3703=A10),--($B$19:$B$3703="Yes"))

--


Regards,


Peo Sjoblom


"Frustrated" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I am tracking my sales reps sales. I currently have a formula to track
>that,
> but now i need to track their sales only if they add a certian feature to
> the
> sale. So now i need to find a formula that tracks their sales if they
> answer
> yes to cell x. If they answer no to cell X i do not want to count that
> sale. Can someone please help. The formula that tracks their individual
> sales is COUNTIF($A$19:$A$3703, A10)



 
Reply With Quote
 
 
 
 
Sean Timmons
Guest
Posts: n/a
 
      5th Nov 2009
so, you're saying you want to count if A19:A3703 equals A10 AND X3:X3703 =
"yes"?

=SUMPRODUCT(($A$19:$A$3703=A10)*($X$19:$X$3703="yes"))

"Frustrated" wrote:

> I am tracking my sales reps sales. I currently have a formula to track that,
> but now i need to track their sales only if they add a certian feature to the
> sale. So now i need to find a formula that tracks their sales if they answer
> yes to cell x. If they answer no to cell X i do not want to count that
> sale. Can someone please help. The formula that tracks their individual
> sales is COUNTIF($A$19:$A$3703, A10)

 
Reply With Quote
 
Jacob Skaria
Guest
Posts: n/a
 
      6th Nov 2009
When you have multiple critiera to be applied to return the count use one of
the below

---When you have multiple criteria use SUMPRODUCT()
'2 criterias
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2))
=SUMPRODUCT((A1:A10=F1)*(B1:B10=F2))

'3 criterias
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2)*(C1:C10=criteria3))
'Wtih cells F1,F2,F3 holding the criteria
=SUMPRODUCT((A1:A10=F1)*(B1:B10=F2)*(C1:C10=F3))

---In case you are using XL 2007 check out help on COUNTIFS()
=COUNTIFS( Criteriarange1,Criteria1,Criteriarange2,Criteria2,...)


If this post helps click Yes
---------------
Jacob Skaria


"Frustrated" wrote:

> I am tracking my sales reps sales. I currently have a formula to track that,
> but now i need to track their sales only if they add a certian feature to the
> sale. So now i need to find a formula that tracks their sales if they answer
> yes to cell x. If they answer no to cell X i do not want to count that
> sale. Can someone please help. The formula that tracks their individual
> sales is COUNTIF($A$19:$A$3703, A10)

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
If a cell equals _, at the next row that equals _, return value fr =?Utf-8?B?Q2F0aHlI?= Microsoft Excel Worksheet Functions 10 2nd May 2007 07:53 PM
If cell is left blank, or equals zero, then cell equals a different cell John McMurry Microsoft Excel Misc 3 13th Apr 2007 01:14 PM
if a:a (range) equals january and c:c equals gas then add g:g ($) =?Utf-8?B?QkNPeg==?= Microsoft Excel Worksheet Functions 4 29th Dec 2005 08:40 PM
Only show rows where T1_F1 equals T2_F1 and T1_F2 equals T2_F2 and =?Utf-8?B?TmljaG9sYXMgS29ybWFuaWs=?= Microsoft Access Queries 3 18th Nov 2005 07:33 AM
custom filter does not work when selecting 'equals' X AND 'equals' =?Utf-8?B?cGxpbmRtYW4=?= Microsoft Excel Misc 1 1st Jun 2005 11:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:09 PM.