I have a table with the following entries:
When I want to count the "1" on every line which starts with J I can use the following Formula
=COUNTIFS(A1:A5;"J";B1:B5;"1")
The result is shown here:
When I now add some collums more and expand the COUNTIF Excel only shows "#VALUE!"
Printscreen:
How can I count all "1" when the first cell in the line starts with "J"?
1
or each row that has at least one1
in it? and what version do you have?1
that are on a line which has aJ
in the "Colum A" So based on my last printscreen it would be4