Formula format for Count or Countif funtion with two criterias

G

Guest

What would be the formula specifics when I want to use the count or countif
funtion with two criteria. Example:
Count A1:A5 and c1:c5
countif A1:A5 equals f and D1:D5 equals h
Countif A1:A5 equals f and count D1:D5
 
G

Guest

=COUNT(A1:A5)+COUNT(C1:C5)
=SUMPRODUCT(--(A1:A5="f"),--(D1:D5="h"))
=SUMPRODUCT(--(A1:A5="f"),--(D1:D5<>""))
 
M

Myrna Larson

For COUNT, you can use a single formula, as it accepts multiple ranges, i.e.

=COUNT(A1:A5,C1:C5)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count and Count if funtions 3
Countif(and 1
Countif Function Using "AND" 3
using CountIF function or Array? 3
Excel function - countif 2
CountIf previous cell formula 0
Help with function 2
COUNTIF with two conditions 2

Top