using sumif & countif to sort multiple cells

G

Guest

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

countif question 3
Is there a formula that can do this? 3
Countif(and 1
Opposite direction 9
Copy Pasting formula's 1
concatenate in combination 3
SUMIF data that falls within a range 3
SUMIF - Sum_Range is misleading 3

Top