例如:
1/10/2006 $1
5/4/2006 $5
9/9/2006 $9
19/10/2006$19
31/10/2006$31
11/10/2006$11
我只係想計算1/10/2006至31/10/2006的數值總和，可以嗎?
如果可以，公式又是怎樣的?
excel可否按指定日期計算數值總和?
2006-11-29 9:56 pm
回答 (2)
2006-11-29 11:20 pm
✔ 最佳答案
先如下左面一行打日期，右面一行打數值，最高用Subtotal計總和。之後用選第一整行然後選 <資料> <篩選> <自動篩選>，再選你要的日期，大於1/10/2006及小於31/10/2006，左面選好，右面便出現總和。=SUBTOTAL(9,C2:C7)
389911
388125
389699
3900919
3902131
3900111
62
1-Oct-061
19-Oct-0619
31-Oct-0631
11-Oct-0611
2006-11-30 9:31 pm
Try this
set the date format in column B
Colum B is the date
Column c is the values
In column D type the following formula
=IF(MONTH(B1)=10,C1,"0")
if the month is 10, then store the values of C in column, else 0
drag the formula to the end of columns
sum the total
hope this help
set the date format in column B
Colum B is the date
Column c is the values
In column D type the following formula
=IF(MONTH(B1)=10,C1,"0")
if the month is 10, then store the values of C in column, else 0
drag the formula to the end of columns
sum the total
hope this help
收錄日期: 2021-04-19 21:03:34
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061129000051KK01441