Multiple Search Criteria "Count"/"SUMPRODUCTIF"

[ugotron]

SUMPRODUCTIF? formula help.

count or sum products that list by week, then by unit, then by section or number 1-6.


I need to be able to filter multiple worksheets same file, for data that has a number 1-6, then filter a second section that lists specific text (between) 6 different organizations, then filter by a work seek of Sunday thru Saturday. and get a count.

For example Week 12
Dog, 1 = 2
Dog, 2 = 1
Dog, 3 = 0
Dog, 4 = 4
Dog, 6 = 7
Cat, 1 = 0
Cat, 2 = 2


then example week 13
and so on....

then example week 14

CPT Ron

 

[VoG]

Apologies, there were errors in my earlier post. Try like this

=SUMPRODUCT(--('sheetname'!$A$2:$A$2000="DOG"), --('sheetname'!$B$2:$B$2000=1), --(sheetname!$C$2:$C$2000>="1/1/2011"+0),--(sheetname!$D$2:$D$2000<="1/3/2011"+0))

or you could try

--(WEEKNUM(sheetname!$C$2:$C$2000)=5)

 

[ugotron]

VoG,

I originally caught the script error.

I also found where I was making my mistake.

My bad, Thank and I am SORRY for the added frustration, but I did see you code....

--(WEEKNUM(sheetname!$C$2:$C$2000)=5) seems much easier...

How do I know the date rages for #5, verses #6 ect....


Thank you so very much for you help. I am getting ready to leave where i am at and I am trying to merger a bunch of data and set files up, so that younger Soldiers can just plug in data for the next two-three years and not worry about messing things up.


CPT Ron