Adds Extra Condition

[Michael168]

Hi!,

In cell K56 has below array formula
=SUM(IF(Full!$AJ$9:$AJ$2038=1,IF(Full!$AC$9:$AC$2038=1,1,0)))

to

cell Q62
=SUM(IF(Full!$AP$9:$AP$2038=1,IF(Full!$AI$9:$AI$2038=1,1,0)))

I like to add in another condition to the all the array formulas in
cell K56:Q62.

e.g. the new formula in Cell K56 becomes
=SUM(IF(Full!$K$9:$K$2038=4,IF(Full!$AJ$9:$AJ$2038=1,IF(Full!$AC$9:$AC$2038=1,1,0))))

How to use vba to add in the extra condition to the existing array
formula?

Regards
Michael

 

[Frank Kabel]

Hi
you may consider using SUMPRODUCT. See:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html