|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 8th, 2005, 01:58 PM
|
|||
|
|||
Counting different colums
I am using this and it works perfectly: =COUNTIF('Issues Registered'!(P:P,"yes") But I want it to look in another column as well (Count "Yes" in column P and all "1" in column G). What am I doing wrong? =COUNTIF('Issues Registered'!(P:P,"yes")(g:g,"1")) Your help will be appreciated Mike  -- gadget ------------------------------------------------------------------------ gadget's Profile: http://www.excelforum.com/member.php...o&userid=28648 View this thread: http://www.excelforum.com/showthread...hreadid=483122 
|
|
#2
November 8th, 2005, 02:06 PM
|
|||
|
|||
|
Counting different colums
=SUMPRODUCT(--(P1:P1000="yes"),--(G1:G1000=1))
-- Regards, Peo Sjoblom "gadget" wrote in message ... I am using this and it works perfectly: =COUNTIF('Issues Registered'!(P:P,"yes") But I want it to look in another column as well (Count "Yes" in column P and all "1" in column G). What am I doing wrong? =COUNTIF('Issues Registered'!(P:P,"yes")(g:g,"1")) Your help will be appreciated Mike -- gadget ------------------------------------------------------------------------ gadget's Profile: http://www.excelforum.com/member.php...o&userid=28648 View this thread: http://www.excelforum.com/showthread...hreadid=483122
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I sort colums | Tony | Running & Setting Up Queries | 4 | May 16th, 2005 12:55 PM |
| Printing Multiple Colums | Daryl B. via AccessMonster.com | Setting Up & Running Reports | 2 | March 31st, 2005 02:44 PM |
| i want my excel colums to be rows | peter | Worksheet Functions | 1 | March 29th, 2005 10:37 PM |
| Counting... | Patrick G | Worksheet Functions | 3 | February 23rd, 2005 10:05 PM |
| Counting Consecutive Days | Mel | Worksheet Functions | 1 | April 28th, 2004 11:13 PM |
Linear Mode
