Sum of values in row if they also correspond to a month?

[ceri_m]

Hi, For each product I have the date it was checked, and a value for if there
are any imperfections, I want a formula that works out how many products
there were with imperfections in any month. Products with any imperfections
have a 1 in that box, each colum represents a product checked.

Month May May May June
Product has imperfection? 1 1 0 1

So I want my formula to return that May has 2 wrong products, June has 1...
I thought it was going to be a simple countif, but i've tried =COUNTIF(B2:E2,
B1:E1="May") and it's just returning a blank! Please help!! I've tried so
many variations of formulas and not getting anywhere!
Thanks
Ceri

 

[Pete_UK]

Try it this way:

=SUMIF(B$1:E$1,"May",B2:E2)

Hope this helps.

Pete