| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Nested Countif
I have a spreadsheet with 2 columns
A B we 6 re 4 re 3 we 6 we 5 How can I do a count of B = 6 and A= we |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Nested Countif
Try this:
=SUMPRODUCT(--(A1:A5="we"),--(B1:B5=6)) -- Biff Microsoft Excel MVP "joshpub" wrote in message ... I have a spreadsheet with 2 columns A B we 6 re 4 re 3 we 6 we 5 How can I do a count of B = 6 and A= we |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Nested Countif
The formula worked I think but no matter the conditions I put it returns the
same answer "T. Valko" wrote: Try this: =SUMPRODUCT(--(A1:A5="we"),--(B1:B5=6)) -- Biff Microsoft Excel MVP "joshpub" wrote in message ... I have a spreadsheet with 2 columns A B we 6 re 4 re 3 we 6 we 5 How can I do a count of B = 6 and A= we |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Nested Countif
WOULD IT HAVE MADE A DIFFERENCE IF THE COLUMNS ARE TEXT?
A B We open Re closed Re open We closed We open "joshpub" wrote: The formula worked I think but no matter the conditions I put it returns the same answer "T. Valko" wrote: Try this: =SUMPRODUCT(--(A1:A5="we"),--(B1:B5=6)) -- Biff Microsoft Excel MVP "joshpub" wrote in message ... I have a spreadsheet with 2 columns A B we 6 re 4 re 3 we 6 we 5 How can I do a count of B = 6 and A= we |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Nested Countif
Just make sure you enclose the TEXT criteria in quotes:
=SUMPRODUCT(--(A1:A5="we"),--(B1:B5="open")) Or, use cells to hold the criteria then you don't have to worry about quotes: D1 = we E1 = open =SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1)) Also note that with SUMPRODUCT you can't use entire columns as range references unless you're using Excel 2007. -- Biff Microsoft Excel MVP "joshpub" wrote in message ... WOULD IT HAVE MADE A DIFFERENCE IF THE COLUMNS ARE TEXT? A B We open Re closed Re open We closed We open "joshpub" wrote: The formula worked I think but no matter the conditions I put it returns the same answer "T. Valko" wrote: Try this: =SUMPRODUCT(--(A1:A5="we"),--(B1:B5=6)) -- Biff Microsoft Excel MVP "joshpub" wrote in message ... I have a spreadsheet with 2 columns A B we 6 re 4 re 3 we 6 we 5 How can I do a count of B = 6 and A= we |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Nested Countif
Thank you that worked perfect
"T. Valko" wrote: Just make sure you enclose the TEXT criteria in quotes: =SUMPRODUCT(--(A1:A5="we"),--(B1:B5="open")) Or, use cells to hold the criteria then you don't have to worry about quotes: D1 = we E1 = open =SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1)) Also note that with SUMPRODUCT you can't use entire columns as range references unless you're using Excel 2007. -- Biff Microsoft Excel MVP "joshpub" wrote in message ... WOULD IT HAVE MADE A DIFFERENCE IF THE COLUMNS ARE TEXT? A B We open Re closed Re open We closed We open "joshpub" wrote: The formula worked I think but no matter the conditions I put it returns the same answer "T. Valko" wrote: Try this: =SUMPRODUCT(--(A1:A5="we"),--(B1:B5=6)) -- Biff Microsoft Excel MVP "joshpub" wrote in message ... I have a spreadsheet with 2 columns A B we 6 re 4 re 3 we 6 we 5 How can I do a count of B = 6 and A= we |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use nested countif statements? | Excel Worksheet Functions | |||
| Nested IF and Countif ? | Excel Worksheet Functions | |||
| nested countif | Excel Worksheet Functions | |||
| Using nested IFs with CountIf | Excel Worksheet Functions | |||
| Nested Countif | Excel Worksheet Functions | |||
Hybrid Mode
