Summation according to date

[jacharya]

Hai,

I needed total sum of number of pages corresponding to date-wise.

[pre]

DATE	  ARTICLES	NO. PAGES	TOTAL

4-Sep-12  PJ2012143	   20
NC201253	   30
SC201298	   32	

5-Sep-12  PJ2012143	   18
NC201253	   32
SC201298	   18

[/pre]
for example: In 4Sep, no of pages=82, so i need this to be done by applying formula

 

[Luke M]

Does your data table truly have gaps in the DATE column like that? If so, we need to first fill in those blanks.


1. Select data column range, down to last used row

2. Ctrl+g, Special Cells, blanks

3. Hit the "=" symbol, and then the up arrow key.

4. Hit Ctrl+Enter to apply formula to all selected cells.


Now, we can easily apply a SUMIF function to get number of pages, ala:

=SUMIF(A:A,DateChosen,C:C)