Arrays

[MARKEGANDERSON]

=SUMPRODUCT(--('Data Page'!A4:A11822="Afghan"),--('Data Page'!F4:F11822="GEN-CAP")+('Data Page'!F4:F11822="GEN-GFE")+('Data Page'!F4:F11822="GEN-AG"),--('Data Page'!H4:H11822="NMC"),--('Data Page'!Y4:Y11822="100")+('Data Page'!Y4:Y11822="149"))

Hello all,

My last 2 arrays: I want to count all my above criteria if Data Page'!Y4:Y11822 is 100 or more but less than 149.

How can I do that?

 

[Aladin Akyurek]

=SUMPRODUCT(--('Data Page'!A4:A11822="Afghan"),--('Data Page'!F4:F11822="GEN-CAP")+('Data Page'!F4:F11822="GEN-GFE")+('Data Page'!F4:F11822="GEN-AG"),--('Data Page'!H4:H11822="NMC"),--('Data Page'!Y4:Y11822="100")+('Data Page'!Y4:Y11822="149"))

Hello all,

My last 2 arrays: I want to count all my above criteria if Data Page'!Y4:Y11822 is 100 or more but less than 149.

How can I do that?

Try...

=SUMPRODUCT(
   --('Data Page'!A4:A11822="Afghan"),
   --ISNUMBER(MATCH('Data Page'!F4:F11822,
        {"GEN-CAP","GEN-GFE","GEN-AG"},0)),
   --('Data Page'!H4:H11822="NMC"),
   --('Data Page'!Y4:Y11822>=100),
   --('Data Page'!Y4:Y11822<=149))

 

[MARKEGANDERSON]

Thanks for the help, but its not working...

Excel propose a correction(eliminating the commas for the last 2 arrays...

Anything else?

 

[Aladin Akyurek]

Thanks for the help, but its not working...

Excel propose a correction(eliminating the commas for the last 2 arrays...

Anything else?

I don't see anything wrong with it... Did you do a copy and paste or re-typed it?

 

[shemayisroel]

I don't see anything wrong with it... Did you do a copy and paste or re-typed it?

Same, looks all good to me, tried it by simply renaming the sheet names to suit my layout and no errors returned.