Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct,Countif, I don't Know!!!!!
Hi, I am trying to count how many record meet three conditions. I have been using a Sumproduct formula for two colums but now I need a hird it is not working. It is hard to descibe but if a Sumproduct formula could work it would look like this: =SUMPRODUCT((MAIN!$AJ$1:$AJ$65534="Stairs")*(MAIN! $B$1:$B$65534="Sick")*(MAIN!$C$1:$C$65534="Door") I know this formula will never work as Sumprduct will only look up two criteria and add a third value. Please; any suggestions would be greatly recieved. Regards G -- Cobbcouk ------------------------------------------------------------------------ Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143 View this thread: http://www.excelforum.com/showthread...hreadid=564924 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct,Countif, I don't Know!!!!!
You're actually very close. Use this:
=SUMPRODUCT(--(MAIN!$AJ$1:$AJ$65534="Stairs"),--(MAIN!$B$1:$B$65534="Sick"),--(MAIN!$C$1:$C$65534="Door")) -- Jim "Cobbcouk" wrote: Hi, I am trying to count how many record meet three conditions. I have been using a Sumproduct formula for two colums but now I need a hird it is not working. It is hard to descibe but if a Sumproduct formula could work it would look like this: =SUMPRODUCT((MAIN!$AJ$1:$AJ$65534="Stairs")*(MAIN! $B$1:$B$65534="Sick")*(MAIN!$C$1:$C$65534="Door") I know this formula will never work as Sumprduct will only look up two criteria and add a third value. Please; any suggestions would be greatly recieved. Regards G -- Cobbcouk ------------------------------------------------------------------------ Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143 View this thread: http://www.excelforum.com/showthread...hreadid=564924 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct,Countif, I don't Know!!!!!
Awesome, thank you, I knew I was in the right area I just could not work out that last step. Again Many Thanks :) -- Cobbcouk ------------------------------------------------------------------------ Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143 View this thread: http://www.excelforum.com/showthread...hreadid=564924 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct,Countif, I don't Know!!!!!
Sorry, can the same formula be used for more criteria/variables, or is it limited to three? -- Cobbcouk ------------------------------------------------------------------------ Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143 View this thread: http://www.excelforum.com/showthread...hreadid=564924 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct,Countif, I don't Know!!!!!
I don't know the limit if there is one. I have never reached it.
-- Jim "Cobbcouk" wrote: Sorry, can the same formula be used for more criteria/variables, or is it limited to three? -- Cobbcouk ------------------------------------------------------------------------ Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143 View this thread: http://www.excelforum.com/showthread...hreadid=564924 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|