Code or formulas, not sure which
 

Hello all.

Going to try to explain as best I can:

I have a spreadsheet that has 40 columns and 1000 rows of data.
Columns I, L, O, R, U, X, AA, and AD have headers of Issue 1, Issue 2
etc. to Issue 8. Each cell in each of the Issue columns could contai
either a blank (no issue found) or a number from 1-16 (reason fo
issue). Column AL has a header of Month.

For each record, the number of issues will vary (Row 2 could have 0
while Row 3 could have 5, Row 4 has 2, etc.). I need to be able t
count the number of Issue "reasons" by month.

I've tried pivot tables, but I don't want it to show by Issue 1, Issu
2 etc. What I would like to end up with (and I can make it work with
lot of formulas, and copy/paste the individual issue columns and th
months into one list and then running the pivot table) is a table tha
has the reasons listed on the left, and the months across the top.

Hopefully there is an easier way, and would appreciate any hel
offered.

Thanks in advance,
Cande

--
Message posted from http://www.ExcelForum.com

Code or formulas, not sure which
 

Have you tried an "If" with a nested "Countif" statement?
If month = x, countif <range= "*"
...dont know if it works but logic should apply.;

--
Message posted from http://www.ExcelForum.com