| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum of values in row if they also correspond to a month?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do make a line correspond to date | Charts and Charting in Excel | |||
| Changing cell colors to correspond to different dates | Excel Worksheet Functions | |||
| Why doesn't the equation correspond to the graphic? | Excel Discussion (Misc queries) | |||
| find value in array on sep sheet & ret correspond val from col lef | Excel Discussion (Misc queries) | |||
| I need a form with 5 buttons that correspond with values 1-5 | Excel Discussion (Misc queries) | |||
![ceri_m[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
