Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum
using formula =SUMIF(range, criteria)
for that range and criteria, can we apply using date instead of range? Such that we the date can be arrange from year 06. So that all information fall under 06 will auto add up. any tips? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum
Try this:
Dates in the range A1:20 Values to sum in the range B1:20 =SUMPRODUCT(--(YEAR(A1:A20)=2006),B1:B20) Biff "kyoshirou" wrote in message ... using formula =SUMIF(range, criteria) for that range and criteria, can we apply using date instead of range? Such that we the date can be arrange from year 06. So that all information fall under 06 will auto add up. any tips? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum
Why the new thread?
kyoshirou wrote: using formula =SUMIF(range, criteria) for that range and criteria, can we apply using date instead of range? Such that we the date can be arrange from year 06. So that all information fall under 06 will auto add up. any tips? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum
Hi Biff,
cant.. the error is #VALUE! Hi Dave, posting another one with no details for easy input. "Biff" wrote: Try this: Dates in the range A1:20 Values to sum in the range B1:20 =SUMPRODUCT(--(YEAR(A1:A20)=2006),B1:B20) Biff "kyoshirou" wrote in message ... using formula =SUMIF(range, criteria) for that range and criteria, can we apply using date instead of range? Such that we the date can be arrange from year 06. So that all information fall under 06 will auto add up. any tips? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|