Occurance of data in multiple columns

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

I have three columns of data. I want to count how many
times all three have specific values. For example,column
A is Day, column A is month, column B is day and column C
is year. How many times will a specific month, day and
year be found.
 
Hi Jerry

one method
assuming your format is
.........A.................B..................C
1....Month..........Day...............Year
2...Jan.................5...................2005
3...Jan................3....................2005


=SUMPRODUCT(--(A2:A9&B2:B9&C2:C9="Jan52005"))

Cheers
JulieD
 
You must log in or register to reply here.

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

Unhide column difficulty 3
Sum with multiple conditions 6
Counting occurences with multiple entries 5
Sumproduct, 3 columns and date 3
Count columns that meet criterias 3
Countif function with multiple column criteria? 8
How to obtain a total count of two columns for a specific product 4
Excel Subtracting multiple columns from another column 3

Back
Top