|
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 |
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 |
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 |
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 |
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 |
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 |
Nested Countif
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "joshpub" wrote in message ... 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 |
| All times are GMT +1. The time now is 04:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com