half yearly total

[vra]

In a huge date wise data how to get half yearly data from April-to -September & then oct to march Then annual total: april to march

 

[anandvarma]

try sumproduct or sumifs

 

[vra]

Can pivot table be helpful?
How to use sumproduct or sum ifs

 

[abmati]

Off course, PivotTable is useful and it is the right tool. But for that in each row you need remarks for the data is 1st half or 2nd half. This can be done by using IF formula as under: If the dates are in column "A"

=IF(A2<=DATE(2011,09,30),"1st Half","2nd Half")

 

[anandvarma]

in the pivot table use grouping in dates column

 

[vra]

Thanks! !
Both of you
i shall try & let u know

 

[vra]

in the pivot table use grouping in dates column

by grouping in dates column m unable to get half yearly total.

 

[vra]

Off course, PivotTable is useful and it is the right tool. But for that in each row you need remarks for the data is 1st half or 2nd half. This can be done by using IF formula as under: If the dates are in column "A"

=IF(A2<=DATE(2011,09,30),"1st Half","2nd Half")

sorry , by this formula i dnt knw why excel is not giving correct 1st half & 2nd half . For every date it is giving 2nd half only.

 

[abmati]

PLEASE CHECK THE FOLLOWING:

Excel Workbook
	A	B
1	01-Apr-11	1st Half
2	11-May-11	1st Half
3	20-Jun-11	1st Half
4	30-Jul-11	1st Half
5	08-Sep-11	1st Half
6	18-Oct-11	2nd Half
7	27-Nov-11	2nd Half
8	06-Jan-12	2nd Half
9	15-Feb-12	2nd Half
10	26-Mar-12	2nd Half
Sheet1

 

[vra]

THANKS , UR FORMULA WORKS, MY DID NOT,...
I wrote same but still it did nt gave me correct result. then i copied ur formula & it gave me correct info