Summing some cells

J

Jim

In cell E1 I will type in Yes or No.

In D1 I would like to count the number of cells that have data in B1:B10,
but only when the Yes or No that is listed in C1:C10 is matched

Thanks for the help
 

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

Conditional Formatting Formula 3
match some character in b1 to c1 and display on d1 3
Baffeling IF statement 7
split range address into individual cell addresses 9
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
compare three cells 1
COUNTING THE SAME VALUES IN A SHEET 3
pop up window 1

Top