can countif function look at 2 separate columns for criteria

B

blake7

I want to use the countif function in excel to look at one criteria in one
column and another criteria in another before summing up, can this be done ?
 
P

Peo Sjoblom

No but you can use SUMPRODUCT,

assume you want to count values in A1: A10 that are greater than 5 and has
the colour red in B1: B10

=SUMPRODUCT(--(A1:A10>5),--(B1:B10="red"))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
D

Daniel CHEN

try to use the following array function:
(array function end with Ctrl+Shift+Enter)

=COUNT(IF((($A$2:$A$8)="A")*(($B$2:$B$8)="A"),$C$2:$C$8))
 
Top