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

Try it this way:

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

Hope this helps.

Pete

On May 9, 9:13*am, ceri_m wrote:
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