count number of csr rep on a column only if anohter columnl is either cancelled or active

**locomambo** · 09-06-2012, 09:59 AM

i need to know how many cancelled does a CSR has searching their rep id and if a sale is either cancelled or active..my spreadsheet has to active sheets..please help..i tried this but didnt work

=counta(Details!$I2:$I,"*110*",if(Details!$V2:$V,"*active*"))
i just need to know how many active sales does a specific rep(using their ID)

**jeffreybrown** · 09-06-2012, 10:04 AM

Try

B2 =COUNTIFS(Sheet1!I:I,A2,Sheet1!V:V,"active")
C2 =COUNTIFS(Sheet1!I:I,A2,Sheet1!V:V,"cancelled")

and copied down

**Kevin UK** · 09-06-2012, 10:12 AM

This is a duplicate post!

http://www.excelforum.com/excel-form...or-active.html

**jeffreybrown** · 09-06-2012, 10:17 AM

Hello locomambo & Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

count number of csr rep on a column only if anohter columnl is either cancelled or active

LinkBack

Thread Tools

Display

count number of csr rep on a column only if anohter columnl is either cancelled or active

Re: count number of csr rep on a column only if anohter columnl is either cancelled or act

Re: count number of csr rep on a column only if anohter columnl is either cancelled or act

Re: count number of csr rep on a column only if anohter columnl is either cancelled or act

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions