Comparing two columns with multiple variables

Hey guys,

I am working on a survey analysis and I'm having trouble comparing two columns.

Ex. 100 surveys
Column A being age (scale of 1-5)
Column B being willingness to pay (scale 1-5)


I am trying to correlate age with willingness to pay by saying =countif(a1:100 = "1" and (B1:B100 = "1" and "2"))
Basically checking to see if the 1st age group has a strong willingness to pay; I would repeat with B1:B100 = "4" and "5"

My assignment is due this week and I was hoping to finish it tonight but haven't been able to figure it out.

Any assistance is greatly appreciated!


Taylor

I've also tried =and(a1:100="1",b1:100="1") but haven't been able to complete the formula

Figured it out; was =countifs :D