Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help 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 urgent
Hi
see your other post P.S.: please don't multipost -----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 urgent
Daniel
Use SUMPRODUCT eg: =SUMPRODUCT((A1:A50="00001001")*(B1:B50=426351)*(C 1:C50="cr")*(D1:D50) PS: assuming column A is text formatted otherwise remove apostrophees (") HTH Cordially Pascal "Daniel Macgaw" a écrit dans le message de ... 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 urgent
STILL NOT WORKING.
-----Original Message----- Daniel Use SUMPRODUCT eg: =SUMPRODUCT((A1:A50="00001001")*(B1:B50=426351) * (C1:C50="cr")*(D1:D50) PS: assuming column A is text formatted otherwise remove apostrophees (") HTH Cordially Pascal "Daniel Macgaw" a écrit dans le message de ... 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. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
help urgent
Hi Daniel
to make it possible for us to identify the error please: - post the EXACT formula used by you - Describe what EXACTLY does not work (e.g. error message, wrong result, etc.) -----Original Message----- STILL NOT WORKING. -----Original Message----- Daniel Use SUMPRODUCT eg: =SUMPRODUCT((A1:A50="00001001")*(B1:B50=426351 )* (C1:C50="cr")*(D1:D50) PS: assuming column A is text formatted otherwise remove apostrophees (") HTH Cordially Pascal "Daniel Macgaw" a écrit dans le message de ... 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. . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Please help very urgent | Excel Discussion (Misc queries) | |||
Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
Macro help urgent urgent | Excel Programming | |||
Macro help urgent urgent | Excel Programming |