D
Daniel Macgaw
my document is in column A
.Column a is merchant id.
.Column a is merchant id.
F
Frank Kabel
Hi
please stay in your original thread
please stay in your original thread
-----Original Message-----
my document is in column A
.
C
Chris
Hi Daniel
You can use an array formula: =SUM(IF(a1:a3=00001001,IF
(b1:b3=426351,d1:d4,0)))
Then press ctrl+shift+enter
You can use an array formula: =SUM(IF(a1:a3=00001001,IF
(b1:b3=426351,d1:d4,0)))
Then press ctrl+shift+enter
S
Soo Cheon Jheong
Daniel,
=SUMPRODUCT(--(A1:A100="00001001"),--(B1:B100=426351),--(C1:C100="cr"),D11
00)
--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--
=SUMPRODUCT(--(A1:A100="00001001"),--(B1:B100=426351),--(C1:C100="cr"),D1
100)
--
Regards,
Soo Cheon Jheong
_ _
^¢¯^
--