Forum Discussion
cheeseontoast101
Oct 18, 2022Copper Contributor
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 have does most of that except the tallying part. How can I fix this?
Attached is an example.
1 Reply
Sort By
- dscheikeyBronze Contributor
Hi! The COUNTIFS() function is made for that.
=COUNTIFS(B2:B7,"SEDAN",C2:C7,"EXACT",D2:D7,"YES")