thanks ken this worked perfect
"floridasurfn" wrote:
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
|