Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF HELP PLEASE
Column C = Date
Column D = Account Number column F = Value I need a sumif formula if the criteria meets both the requirements, =SUMIF(C2:C146=11/01/04)*(D2:D146=3)*(F2:F146)) It is not meeting the second criterua of the date and it is suming all the "3" Account Numbers. It should bring back the one value and not double it. Thank you. Lou |
#2
|
|||
|
|||
Hi
=SUMPRODUCT(--(C2:C146=DATE(2004,11,1)),--(D2:D146=3),F2:F146) Also see: http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Regards Frank Kabel Frankfurt, Germany "LOU" schrieb im Newsbeitrag ... Column C = Date Column D = Account Number column F = Value I need a sumif formula if the criteria meets both the requirements, =SUMIF(C2:C146=11/01/04)*(D2:D146=3)*(F2:F146)) It is not meeting the second criterua of the date and it is suming all the "3" Account Numbers. It should bring back the one value and not double it. Thank you. Lou |
#3
|
|||
|
|||
Hi
=SUMPRODUCT(--(C2:C146=DATE(2004,1,11)),--(D2:D146=3),(F2:F146)) Arvi Laanemets "LOU" wrote in message ... Column C = Date Column D = Account Number column F = Value I need a sumif formula if the criteria meets both the requirements, =SUMIF(C2:C146=11/01/04)*(D2:D146=3)*(F2:F146)) It is not meeting the second criterua of the date and it is suming all the "3" Account Numbers. It should bring back the one value and not double it. Thank you. Lou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
sumif to add data in multiple sheets | Excel Worksheet Functions | |||
Is it possible to specify multiple condition with SUMIF? | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |