Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping
Hi,
Col A contains dates "dd/mm/yyyy" Col B Contains values C1 is a variable month number 1-12 D1 is a variable year I need E1 to sum all values in Col B that match the coresponding date of Col A based on the criteria set in C1 & D1. Thanks. LaDdIe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping
Try this
=SUMPRODUCT((MONTH(A1:A20)=C1)*(YEAR(A1:A20)=D1)*( B1:B20)) Mike "LaDdIe" wrote: Hi, Col A contains dates "dd/mm/yyyy" Col B Contains values C1 is a variable month number 1-12 D1 is a variable year I need E1 to sum all values in Col B that match the coresponding date of Col A based on the criteria set in C1 & D1. Thanks. LaDdIe |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping
On Sun, 7 Dec 2008 07:10:01 -0800, LaDdIe
wrote: Hi, Col A contains dates "dd/mm/yyyy" Col B Contains values C1 is a variable month number 1-12 D1 is a variable year I need E1 to sum all values in Col B that match the coresponding date of Col A based on the criteria set in C1 & D1. Thanks. LaDdIe Try this formula in cell E1: =SUMPRODUCT((YEAR(A1:A10)=D1)*(MONTH(A1:A10)=C1)*( B1:B10)) Change the 10 in three place to cover then number of rows with data in columns A and B. Hope this helps / Lars-Åke |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping
Thanks :)
"LaDdIe" wrote: Hi, Col A contains dates "dd/mm/yyyy" Col B Contains values C1 is a variable month number 1-12 D1 is a variable year I need E1 to sum all values in Col B that match the coresponding date of Col A based on the criteria set in C1 & D1. Thanks. LaDdIe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with looping | Excel Programming | |||
Not Looping Through | Excel Programming | |||
Looping | Excel Programming | |||
Looping | Excel Programming | |||
Looping | Excel Programming |