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
sales is COUNTIF(\$A\$19:\$A\$3703, A10)

Peo Sjoblom
Guest
Posts: n/a

 5th Nov 2009

=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
> yes to cell x. If they answer no to cell X i do not want to count that
> sales is COUNTIF(\$A\$19:\$A\$3703, A10)

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
> sales is COUNTIF(\$A\$19:\$A\$3703, A10)

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
> sales is COUNTIF(\$A\$19:\$A\$3703, A10)

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?Q2F0aHlI?= Microsoft Excel Worksheet Functions 10 2nd May 2007 07:53 PM John McMurry Microsoft Excel Misc 3 13th Apr 2007 01:14 PM =?Utf-8?B?QkNPeg==?= Microsoft Excel Worksheet Functions 4 29th Dec 2005 08:40 PM =?Utf-8?B?TmljaG9sYXMgS29ybWFuaWs=?= Microsoft Access Queries 3 18th Nov 2005 07:33 AM =?Utf-8?B?cGxpbmRtYW4=?= Microsoft Excel Misc 1 1st Jun 2005 11:29 PM

Features