| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Hi
sorry, forget this use =SUMPRODUCT(--(A1:A100=""w"),--(B1:B100="Head")) -- Regards Frank Kabel Frankfurt, Germany Frank Kabel wrote: Hi =SUMIF(A1:A100,"2W",B1:B100) Urgent wrote: I have 2 columns, one labeled "unit" and the other "injury type". So there are about 8 different units all numbered like "2W, 2E, 3W, 3E, etc." and the injury types has "head, eye, hand, etc". I need help to create a formula, for example that will pull out all the head injuries that happend in 2W. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colors of columns after sorting data in the supporting table | Charts and Charting in Excel | |||
| My Pivot total just repeats item data | Excel Discussion (Misc queries) | |||
| Drop-down selection fills data across multiple columns | Excel Discussion (Misc queries) | |||
| Lookup Data in Several Columns | Excel Worksheet Functions | |||
| Comparing Data in two columns | Excel Worksheet Functions | |||
Hybrid Mode
