| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
compare columns and count
2 examples which should quickly give you the grasp of it ..
=SUMPRODUCT((A1:A10=2008)*(B1:B10="Dropped")) returns the count where col A = 2008, and col B = Dropped =SUMPRODUCT((A1:A10=2008)*(ISNUMBER(MATCH(B1:B10,{ "Dropped";"Rolled"},0)))) returns the count where col A = 2008, and col B = either Dropped or Rolled Splendid? Click YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:23,500 Files:370 Subscribers:66 xdemechanik --- "GireeshaJ" wrote: A B 2008 Dropped 2007 rolled 2008 expired here i want to count in 2008/2007, how many are dropped or rolled ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare lists - count # records | Excel Worksheet Functions | |||
| SUMPRODUCT formula compare then count | Excel Worksheet Functions | |||
| How do I compare two columns and return a number count | Excel Worksheet Functions | |||
| need to compare dates and count results | Excel Worksheet Functions | |||
| Compare columns, count matches | Excel Worksheet Functions | |||
Threaded Mode
