Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf - 2 Criteria
Hey,
I've read some posts on 2 criteria for the countif/sumif functions, but I can't seem to get it to work for me. In one column (column I), I have 2 letter initials (AB, CD, EF, etc.). In another column, (column F), there is either a date or it's blank. I want to count the number of times "AB" shows up in column I when there is data in column F (ie, when column F is not empty). How can I do this? Thanks! Brett |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf - 2 Criteria
One way:
=SUMPRODUCT(--(I1:I1000="AB"),--(F1:F1000<"")) In article .com, wrote: Hey, I've read some posts on 2 criteria for the countif/sumif functions, but I can't seem to get it to work for me. In one column (column I), I have 2 letter initials (AB, CD, EF, etc.). In another column, (column F), there is either a date or it's blank. I want to count the number of times "AB" shows up in column I when there is data in column F (ie, when column F is not empty). How can I do this? Thanks! Brett |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf - 2 Criteria
Hi,
Thanks for this. It works, but only if the range is on the same tab as the calculation. Do you know if it should work if the range is on a separate tab? Thanks! On May 14, 12:34 pm, JE McGimpsey wrote: One way: =SUMPRODUCT(--(I1:I1000="AB"),--(F1:F1000<"")) In article .com, wrote: Hey, I've read some posts on 2 criteria for the countif/sumif functions, but I can't seem to get it to work for me. In one column (column I), I have 2 letter initials (AB, CD, EF, etc.). In another column, (column F), there is either a date or it's blank. I want to count the number of times "AB" shows up in column I when there is data in column F (ie, when column F is not empty). How can I do this? Thanks! Brett- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf - 2 Criteria
Nevermind, it works in separate tabs, but not if I choose a whole
column... Thanks! On May 14, 1:10 pm, wrote: Hi, Thanks for this. It works, but only if the range is on the same tab as the calculation. Do you know if it should work if the range is on a separate tab? Thanks! On May 14, 12:34 pm, JE McGimpsey wrote: One way: =SUMPRODUCT(--(I1:I1000="AB"),--(F1:F1000<"")) In article .com, wrote: Hey, I've read some posts on 2 criteria for the countif/sumif functions, but I can't seem to get it to work for me. In one column (column I), I have 2 letter initials (AB, CD, EF, etc.). In another column, (column F), there is either a date or it's blank. I want to count the number of times "AB" shows up in column I when there is data in column F (ie, when column F is not empty). How can I do this? Thanks! Brett- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two criteria for CountIf? | Excel Worksheet Functions | |||
More than 1 countif criteria | Excel Discussion (Misc queries) | |||
COUNTIF with two criteria | Excel Worksheet Functions | |||
Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
Countif using format criteria....not number criteria? | Excel Worksheet Functions |