How to calculate total quarter wise

[lovedeep sharma]

 

[oldbrewer]

this time your picture is visible - explain in words what you want - the font is so small I cannot read it.

 

[bhos123]

do you have multiple entries in column A
if No,

1> use the SUM($B2:$E2) for Q1 and SUM($F2:$I2) for Q2 and drag them down, and put O2=A2. you will get the list in same order...

If Yes, then I have a bit lengthy solution.

For Q1 use SUMIF($A:$A,Q2,$B:$B)+SUMIF($A:$A,Q2,$C:$C)+SUMIF($A:$A,Q2,$D:$D)+SUMIF($A:$A,Q2,$E:$E)

 

[bhos123]

@ Sharma.. your inbox is full. delete some of the messages from your inbox. I am sending you the reply.