allison
02-21-2008, 07:08 AM
I think that I just can't get the syntax correct and can't figure out what I'm doing wrong.
I have three data ranges:
TEAM -- the values in here are from a VLOOKUP
MONTH -- mm/dd/yyyy format
JUSTIFIED -- Yes/No text
Using what XLD suggested yesterday worked great for finding the number of records in the month that are justified:
SUMPRODUCT(--((month)=$C$1),--(justified="Yes"))
I now want to break things down by team:
# records by team for the month
# records by team for the month that are justified
I thought that I could just incorporate the team part, but I keep getting either #VALUE or #N/A
=SUMPRODUCT(--(T(team="B")),--((month)=$C$1),--(justified="Yes"))
Any suggestions?
I have three data ranges:
TEAM -- the values in here are from a VLOOKUP
MONTH -- mm/dd/yyyy format
JUSTIFIED -- Yes/No text
Using what XLD suggested yesterday worked great for finding the number of records in the month that are justified:
SUMPRODUCT(--((month)=$C$1),--(justified="Yes"))
I now want to break things down by team:
# records by team for the month
# records by team for the month that are justified
I thought that I could just incorporate the team part, but I keep getting either #VALUE or #N/A
=SUMPRODUCT(--(T(team="B")),--((month)=$C$1),--(justified="Yes"))
Any suggestions?