| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf for a range with multiple criteria
Hello. I want to make a count concerning two columns A and B.
The column A has text such as TT and TP the column B has numbers. example A B TT 2 TP 5 TT 0 TT 1 I need to count how many times I have TT on columns A that the value on column B is higher then 0 How? Regards, Marco |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CountIf for a range with multiple criteria
=SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40))
Better to put the "TT" & "1" in cells e.g X1, X2: =SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2)) "Marco" wrote: Hello. I want to make a count concerning two columns A and B. The column A has text such as TT and TP the column B has numbers. example A B TT 2 TP 5 TT 0 TT 1 I need to count how many times I have TT on columns A that the value on column B is higher then 0 How? Regards, Marco |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CountIf for a range with multiple criteria
Hello. I couldn't put this working, but tell me, what happens if the TP has
also 0 on column B? Regards, Marco "Toppers" wrote: =SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40)) Better to put the "TT" & "1" in cells e.g X1, X2: =SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2)) "Marco" wrote: Hello. I want to make a count concerning two columns A and B. The column A has text such as TT and TP the column B has numbers. example A B TT 2 TP 5 TT 0 TT 1 I need to count how many times I have TT on columns A that the value on column B is higher then 0 How? Regards, Marco |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CountIf for a range with multiple criteria
TP is ignored.
Is column B text or numberic: if text change 0 to "0". Worked fine for me ... what result did you get? "Marco" wrote: Hello. I couldn't put this working, but tell me, what happens if the TP has also 0 on column B? Regards, Marco "Toppers" wrote: =SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40)) Better to put the "TT" & "1" in cells e.g X1, X2: =SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2)) "Marco" wrote: Hello. I want to make a count concerning two columns A and B. The column A has text such as TT and TP the column B has numbers. example A B TT 2 TP 5 TT 0 TT 1 I need to count how many times I have TT on columns A that the value on column B is higher then 0 How? Regards, Marco |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CountIf for a range with multiple criteria
....numberic???? ...numeric!
"Toppers" wrote: TP is ignored. Is column B text or numberic: if text change 0 to "0". Worked fine for me ... what result did you get? "Marco" wrote: Hello. I couldn't put this working, but tell me, what happens if the TP has also 0 on column B? Regards, Marco "Toppers" wrote: =SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40)) Better to put the "TT" & "1" in cells e.g X1, X2: =SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2)) "Marco" wrote: Hello. I want to make a count concerning two columns A and B. The column A has text such as TT and TP the column B has numbers. example A B TT 2 TP 5 TT 0 TT 1 I need to count how many times I have TT on columns A that the value on column B is higher then 0 How? Regards, Marco |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
CountIf for a range with multiple criteria
It worked, thanks a lot.
Regards, marco "Toppers" wrote: ...numberic???? ...numeric! "Toppers" wrote: TP is ignored. Is column B text or numberic: if text change 0 to "0". Worked fine for me ... what result did you get? "Marco" wrote: Hello. I couldn't put this working, but tell me, what happens if the TP has also 0 on column B? Regards, Marco "Toppers" wrote: =SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40)) Better to put the "TT" & "1" in cells e.g X1, X2: =SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2)) "Marco" wrote: Hello. I want to make a count concerning two columns A and B. The column A has text such as TT and TP the column B has numbers. example A B TT 2 TP 5 TT 0 TT 1 I need to count how many times I have TT on columns A that the value on column B is higher then 0 How? Regards, Marco |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I put a date range in the criteria of a countif formula? | Excel Discussion (Misc queries) | |||
| Excel COUNTIF Function - a range as criteria ? | Excel Worksheet Functions | |||
| SUM(COUNTIF(range,NOT Criteria)) | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
