using sumif & countif to sort multiple cells

F

floridasurfn

i have this information:

A1= YES B1=YES C1=10
A2= YES B2=NO C2=15
A3= NO B3=NO C3=25
A4=YES B4=NO C4=6
A5=YES B5=YES C5=11

I would like to sumif, range a1:a5 =yes & range b1:b5 =yes, then sum range
c1:c5
Can a formula check ranges and return (21) which is sum of 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

Calculate end date and time 1
Urgent help with Excel formula. Please please help 1
Countif(and 2
Is there a formula that can do this? 3
Opposite direction 9
countif question 3
SUMIF data that falls within a range 3
Complicated IF statement - desperately need some help 4

Top