| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF with 2 creteria one Name one DAte
A1_A5 Name Brian, Chris, Brian , Chris, Brian
B1_B5 Date 1/1/2006, 2/15/2006, 1/15/2006, 2/29/2006, 2/3/2006 C1_C5 $ 100, 150 , 250, 95, 10 I Need How many times Brian sold somthin in january (2) or Chris (0) in february Chris (2) brian (1) How many Money January Brian (350) or Chris (0) in february Chris (245) brian (10) i like to use sumif ??? for the money and countif ????? for Sales but i dnt know the formulars. Ineed help Thank You Rolf |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| how to use sumif function to check date in 1 sheet is < 2 sheet | Excel Worksheet Functions | |||
| Another Date issue. | Excel Worksheet Functions | |||
| sumif using today's date | Excel Discussion (Misc queries) | |||
Threaded Mode
