Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help wanted urgent
my document is in column A:D.Column a is merchant id.
column b is bin number. column c is cr/dr and column d is the amount. I want to write a formula to check if column a, b & c = the true value that I want and if true, sums D:D. Example: column A column b column c column d 00001001 426351 cr 10.00 00001001 405262 cr 10.00 00001002 426351 dr 10.00 I want to write a formula that check if cloumn a = 00001001, b= 426351, c=cr, then sum d:d. . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
help wanted urgent
Hi
please stay in your original thread :-) -----Original Message----- my document is in column A:D.Column a is merchant id. column b is bin number. column c is cr/dr and column d is the amount. I want to write a formula to check if column a, b & c = the true value that I want and if true, sums D:D. Example: column A column b column c column d 00001001 426351 cr 10.00 00001001 405262 cr 10.00 00001002 426351 dr 10.00 I want to write a formula that check if cloumn a = 00001001, b= 426351, c=cr, then sum d:d. . . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help wanted urgent
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 -----Original Message----- my document is in column A:D.Column a is merchant id. column b is bin number. column c is cr/dr and column d is the amount. I want to write a formula to check if column a, b & c = the true value that I want and if true, sums D:D. Example: column A column b column c column d 00001001 426351 cr 10.00 00001001 405262 cr 10.00 00001002 426351 dr 10.00 I want to write a formula that check if cloumn a = 00001001, b= 426351, c=cr, then sum d:d. . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
help wanted urgent
Daniel,
=SUMPRODUCT(--(A1:A100="00001001"),--(B1:B100=426351),--(C1:C100="cr"),D1:D1 00) -- Regards, Soo Cheon Jheong _ _ ^ąŻ^ -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Help Wanted | Excel Worksheet Functions | |||
Just wanted to say thanks! | Excel Discussion (Misc queries) | |||
urgent vba code wanted | Excel Programming | |||
Licence help wanted | Excel Programming |