count occurances of values in column if condition is met

R

Robert H

From a cell I need to look down column B and for each time there is
the value “Ship Effort” I need to look in Column E and count the
occurrences of items in range “SysListName” .

For example if SysListName
A
B
C
D

And Column B =
Admin
Admin
Ship Effort
Ship Effort
Ship Effort

And Column E =
A
A
A
B
R

The formula would return “2”

and help will be appreciated
Robert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting unique values in multiple columns 4
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Copy cells to different sheet if value found 1
Data Validation and drop-down list using IF, AND and what else? 8
Comparing two columns and returning value from another column 1
Vlookup or similar 7
Column data comparison - what has been deleted and what has been added 8
Count Conditional formating data 3

Top