ExcelBanter - helps with count under multiple condition

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - helps with count under multiple condition (https://www.excelbanter.com/excel-discussion-misc-queries/133788-helps-count-under-multiple-condition.html)

Cam

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..

Toppers

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..

All times are GMT +1. The time now is 08:33 PM.