Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |