Adds Extra Condition
 

Hi!,

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

to

cell Q62
=SUM(IF(Full!$AP$9:$AP$2038=1,IF(Full!$AI$9:$AI$20 38=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


--
Michael168
------------------------------------------------------------------------
Michael168's Profile: http://www.excelforum.com/member.php...nfo&userid=605
View this thread: http://www.excelforum.com/showthread...hreadid=273640

Adds Extra Condition
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Michael168 wrote:
Hi!,

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

to

cell Q62
=SUM(IF(Full!$AP$9:$AP$2038=1,IF(Full!$AI$9:$AI$20 38=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