| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
helps with count under multiple condition
Hi,
I need help with count results of column B when it met two criteria in column A & E. I am not sure what function to perform. COUNTIF, MATCH etc.. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
helps with count under multiple condition
Look at SUMPRODUCT:
=SUMPRODUCT(--(A1:A100=Criteria1),--(E1:E100=Criteria2),(B1:B100)) You can put the criteria in a cell Note: ranges cannot be whole columns. HTH "Cam" wrote: Hi, I need help with count results of column B when it met two criteria in column A & E. I am not sure what function to perform. COUNTIF, MATCH etc.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells with condition | Excel Worksheet Functions | |||
| count col-A if col-B = condition | Excel Worksheet Functions | |||
| What formula/fn would I use to count multiple condition records? | Excel Worksheet Functions | |||
| Count the occurence of more than one condition | Excel Worksheet Functions | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
Linear Mode
