Forum Discussion
Tally if statement
Hi I'm not sure if I've selected the right functions but what I want basically is: If B3:B7 says Sedan and C3:C7 says EXACT and D3:D7 says yes + 1 for each time it specifies this. The formula I...
Hi! The COUNTIFS() function is made for that.
=COUNTIFS(B2:B7,"SEDAN",C2:C7,"EXACT",D2:D7,"YES")