| Home |
| Search |
| Today's Posts |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT based on 2 criteria
BTW, note my comment about redundancy
=SUMPRODUCT(--(Store=123),--(InvID=16),--(Purchases0)) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ... Thank you Mike, excatly what I need Bob, was looking to count the number of receipts for a particular store and inventory item. My example 2 receipts were receeived for the data in question |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count based on criteria | Excel Discussion (Misc queries) | |||
| Count based on multiple criteria | Excel Worksheet Functions | |||
| Need to count based on different criteria in two columns | Excel Worksheet Functions | |||
| Count distinct based on criteria | Excel Worksheet Functions | |||
| Count or Sum based on more than 1 criteria | Excel Worksheet Functions | |||
Threaded Mode
