Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 5th 09, 09:37 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 55
Default Counting cells only if cell X equals "yes"

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)

  #2   Report Post  
Old November 5th 09, 09:46 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 103
Default Counting cells only if cell X equals "yes"

=countif($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)


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200911/1

  #3   Report Post  
Old November 5th 09, 09:47 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 136
Default Counting cells only if cell X equals "yes"

Please refrain from multiposting


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

--


Regards,


Peo Sjoblom


"Frustrated" wrote in message
...
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)



  #4   Report Post  
Old November 5th 09, 09:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 1,696
Default Counting cells only if cell X equals "yes"

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="ye s"))

"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)

  #5   Report Post  
Old November 6th 09, 05:59 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default Counting cells only if cell X equals "yes"

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 mh Excel Worksheet Functions 5 July 27th 09 02:40 AM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
if cell equals "a" then another cell would calculate percentage Brandy Excel Worksheet Functions 1 June 20th 08 05:18 PM
Sumif formula that uses "contains" rather than "equals" jerrymcm Excel Discussion (Misc queries) 4 October 2nd 07 05:15 PM
In excel counting cells in a range which meet condition "Xand<X" Uncivil Servant Excel Worksheet Functions 1 May 19th 06 02:37 PM


All times are GMT +1. The time now is 06:29 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017