Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Complicated.
I have numbers 1-10 in Column A.. I am only interested in the number 2..
Column b has dates.. 1/24/2006 is the day i also want.. if column a is 2, and b is 01/24/06, then i need it to sum whats it is in row U for that cell. here is what i have.. i basically need 2 criterias.. and im stumped. =SUMIF($A$2:$A$64000,2,$U$2:$U$64000) help please. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Complicated.
ok i tried sumproduct but i dont think its reading my dates.. I keep getting 0
=SUMPRODUCT(--(A2:A64000="2"),--(B2:B64000="1/24/2006"),U2:U64000) help "cbanks" wrote: I have numbers 1-10 in Column A.. I am only interested in the number 2.. Column b has dates.. 1/24/2006 is the day i also want.. if column a is 2, and b is 01/24/06, then i need it to sum whats it is in row U for that cell. here is what i have.. i basically need 2 criterias.. and im stumped. =SUMIF($A$2:$A$64000,2,$U$2:$U$64000) help please. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Complicated.
Your formula is nearly there... try it without the quotes around 2 (if 2 is a number) and a +0 after the date like this =SUMPRODUCT(--(A2:A64000=2),--(B2:B64000="1/24/2006"+0),U2:U64000) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=505089 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF Complicated.
=SUMPRODUCT(--(A2:A64000="2"),--(B2:B64000=DATE(2006, 1,
24)),U2:U64000) HTH Kostis Vezerides |
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 | |||
Complicated SUMPRODUCT OR SUMIF question? | Excel Discussion (Misc queries) | |||
Complicated SUMIF Case | Excel Discussion (Misc queries) | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) |