Possible Lookup
Thank you for your help!
"T. Valko" wrote:
Is there a column for the dept number?
Try something like this. Assuming column A is the dept number.
=SUMPRODUCT(--(A1:A100=3001),--(MONTH(D1:D100)=1),--(H1:H100=1))
That will count entries for dept 3001 for the month of January with error
code 1.
Better to use cells to hold the criteria:
N1 = dept number = 3001
O1 = month number = 1 (months 1-12)
P1 = error level code = 1
=SUMPRODUCT(--(A1:A100=N1),--(MONTH(D1:D100)=O1),--(H1:H100=P1))
--
Biff
Microsoft Excel MVP
"Karen" wrote in message
...
Using Excel 2003
I have a spreadsheet that tracks errors for 3 departments.
3001
3002
3003
Not sure if you need ALL this info, but I'll give it to you if you do.
The spreadsheet has 12 columns (A thru L)
Column D (Date Discovered) contains the date I want to use to segregate
the
errors.
Column H (Level) contains the number of the error level. There are 3
levels
(Level 1,2, & 3)
All I want to do is total the amount of errors by department, by level and
by month.
Should I use the Lookup function for something like this? If so, how do I
go
about this? Can someone lead me in the right direction?
Thank you, Karen
|