Sum

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Sort by date Sort by votes
GroupNamePayment Received AmtCreteria
Delhi3,357.00DelhiAll Creteria data need here
Delhi15,340.00Haryana
Delhi81,303.00Jammu & Kashmir
Kerala22,326.00Uttranchal
Kerala3,784.00Uttrakhand
Kerala73,948.00Western UP
Delhi-180
Delhi50,180.00
Delhi15,883.00
Delhi94,117.00
Gujarat1,666.00
Gujarat1,038.00
Gujarat-3,475.00
Gujarat47,291.00
Gujarat1,219.00
Gujarat983
Gujarat652
Gujarat-657
Gujarat-983
Gujarat-3,094.00
Gujarat-971
Gujarat-1,083.00
Gujarat-677
Gujarat-893
Gujarat-809
Gujarat-3,665.00
Gujarat-1,019.00
Gujarat-1,019.00
Gujarat-1,019.00
Gujarat657
Gujarat3,475.00
Gujarat-1,133.00
Gujarat-3,475.00
Gujarat1,028.00
Gujarat13,841.00
Gujarat1,028.00
Delhi7,42,768.00
Delhi840
Delhi50,000.00
Delhi-5,00,000.00
Delhi1,41,702.00
Delhi1,76,268.00
Delhi1,79,872.00
Delhi20,697.00
Delhi61,169.00
Delhi66,493.00
Delhi1,16,515.00
Kerala26,278.00
Kerala-11,706.00
Kerala-10,535.00
Kerala-4,038.00
Kerala39,928.00
Kerala20,720.00
Kerala66,021.00
Delhi6,884.00
Kerala20,819.00
Delhi60,292.00
Delhi39,708.00
Bihar1,72,671.00
Bihar49,055.00
Bihar23,134.00
Bihar10,259.00
Bihar96,311.00
Bihar37,730.00
Bihar35,525.00
Bihar43,374.00
Bihar13,423.00
Bihar10,718.00
Bihar7,800.00
Delhi50,000.00
Delhi50,000.00
Kerala29,487.00
Delhi16,317.00
Bihar15,000.00
Gujarat19,022.00
Gujarat13,014.00
Karnataka40,862.00
Assam20,000.00
Delhi-690
Delhi38,927.00
Delhi26,834.00
Karnataka3,472.00
Karnataka16,528.00
Delhi2,065.00
Delhi-2,065.00
Delhi36,231.00
Delhi-950
Delhi50,000.00
Haryana36,827.00
Kerala37,617.00
Kerala26,273.00
Delhi6,170.00
Delhi43,830.00
Karnataka968
Karnataka5,880.00
Karnataka13,152.00
Delhi3,67,160.00
Delhi50,000.00
Kerala2,18,304.00
Kerala-13,026.00
Kerala-584
Kerala-903
Kerala-1,232.00
Kerala-371
Kerala-2,188.00
Delhi3,12,413.00
Delhi89,457.00
Delhi-1,77,443.00
Delhi-15,775.00
Delhi-8,652.00
Delhi50,000.00
Jharkand23,256.00
Jharkand-1,575.00
Delhi50,000.00
Himachal Pradesh72,261.00
Kerala7,594.00
Kerala42,406.00
Delhi78
Delhi1,102.00
Delhi-1,870.00
Delhi19,222.00
Eastern UP11,644.00
Eastern UP22,820.00
Eastern UP26,473.00
Eastern UP70,452.00
Eastern UP65,564.00
Eastern UP31,938.00
Delhi6,884.00
Delhi11,950.00
Delhi348
Kerala-1,093.00
Kerala30,099.00
Haryana4,312.00
Kerala1,43,325.00
Kerala3,671.00
Kerala1,301.00
Kerala3,881.00
Kerala-3,881.00
Delhi17,627.00
Delhi44,167.00
Delhi32,303.00
Delhi1,232.00
Delhi10,137.00
Delhi50,000.00
Karnataka-22,689.00
Karnataka10,136.00
Karnataka6,597.00
Karnataka11,664.00
Karnataka1,624.00
Karnataka1,434.00
Assam1,00,000.00
Kerala52,998.00
Kerala100
Kerala-430
Kerala-1,090.00
Kerala-1,760.00
Kerala-1,040.00
Kerala-1,198.00
Kerala-1,080.00
Haryana50,000.00
Eastern UP78,231.00
Karnataka1,00,000.00
Kerala-3,913.00
Kerala33,141.00
Kerala2,430.00
Karnataka2,979.00
Karnataka7,021.00
Kerala25,000.00
Karnataka644
Karnataka17,356.00
Chandigarh68,932.00
Chandigarh31,068.00
Kerala8,288.00
Kerala-5,320.00
Kerala21,437.00
Kerala8,883.00
Delhi34,857.00
Kerala-1,009.00
Kerala21,000.00
Kerala1,35,517.00
Kerala1,94,492.00
Delhi50,349.00
Delhi4,177.00
Delhi70,474.00
Kerala13,674.00
Karnataka3,864.00
Karnataka11,637.00
Karnataka5,499.00
Karnataka28,918.00
Karnataka6,496.00
Assam30,442.00
Assam19,001.00
Delhi1,486.00
Delhi1,215.00
Delhi-1,881.00
Delhi23,059.00
Himachal Pradesh25,000.00
Assam13,474.00
Assam8,534.00
Assam17,992.00
Bihar481
Bihar14,519.00
Kerala1,274.00
Kerala2,968.00
Kerala22,786.00
Kerala2,397.00
Kerala275
Kerala-3,450.00
Kerala-1,064.00
Jharkand16,000.00
Delhi27,516.00
Delhi22,484.00
Karnataka50,000.00
Delhi1,210.00
Delhi27,898.00
Bihar6,905.00
Bihar2,039.00
Bihar6,056.00
Karnataka9,218.00
Karnataka20,782.00
Karnataka19,600.00
Karnataka7,784.00
Delhi2,20,000.00
Delhi-20,000.00
Eastern UP5,585.00
Eastern UP4,989.00
Eastern UP28,102.00
Eastern UP4,211.00
Eastern UP1,216.00
Eastern UP3,023.00
Eastern UP6,600.00
Eastern UP3,326.00
Eastern UP4,794.00
Eastern UP1,150.00
Eastern UP8,290.00
Eastern UP56,759.00
Eastern UP13,614.00
Eastern UP1,19,225.00
Eastern UP39,116.00
Kerala-1,736.00
Kerala-3,650.00
Kerala34,675.00
Assam6,753.00
Assam-1,138.00
Delhi10,000.00
Karnataka348
Karnataka-1,131.00
Karnataka1,274.00
Karnataka-940
Karnataka1,659.00
Karnataka12,423.00
Karnataka44,520.00
Karnataka10,037.00
Assam73,559.70
Assam16,850.00
Assam9,584.40
Eastern UP0
Assam0
Delhi0
Karnataka0

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
 
Upvote 0
How about


Excel 2013/2016
ABCDE
1GroupNamePayment Received AmtCreteria
2Delhi3,357.00Delhi1,543,806.00
3Delhi15,340.00Haryana91,139.00
4Delhi81,303.00Kerala631,182.00
5Kerala22,326.00Uttranchal0.00
6Kerala3,784.00Uttrakhand0.00
7Kerala73,948.00Western UP0.00
8Delhi-180
9Delhi50,180.00
10Delhi15,883.00
11Delhi94,117.00
12Gujarat1,666.00
13Gujarat1,038.00
14Gujarat-3,475.00
15Gujarat47,291.00
16Gujarat1,219.00
17Gujarat983
18Gujarat652
VBAinputs
Cell Formulas
RangeFormula
E2=SUMIF(A:A,D2,B:B)
 
Upvote 0
Have you tried the formula I suggested?
 
Upvote 0
But its work individually criteria cell. But i need the data in a single cell. Any budy can help me in this situation
 
Upvote 0
Rajakr43 said:
But i need the data in a single cell.
Click to expand...

Hi, you could try..


Excel 2013/2016
ABCDE
1GroupNamePayment Received AmtCreteriaFormula
2Delhi3357Delhi360058
3Delhi15340Haryana
4Delhi81303Kerala
5Kerala22326Uttranchal
6Kerala3784Uttrakhand
7Kerala73948Western UP
8Delhi-180
9Delhi50180
10Delhi15883
11Delhi94117
12Gujarat1666
13Gujarat1038
14Gujarat-3475
15Gujarat47291
16Gujarat1219
17Gujarat983
18Gujarat652
Sheet1
Cell Formulas
RangeFormula
E2=SUMPRODUCT(SUMIFS(B:B,A:A,D2:D7))
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Sumifs, Index, formula only summing first value
Replies
1
Views
300
etaf
etaf
N
  • Solved
Sum row data based on criterias in head row
Replies
2
Views
75
Neomatrix
N
N
  • Solved
Stumped by Sum and Countifs Formula
Replies
5
Views
138
Peter_SSs
Peter_SSs
P
  • Question
Sumifs from the List of criteria
Replies
1
Views
121
awoohaw
awoohaw
E
  • Question
Sum multiple columns with Sumif Index Match
Replies
1
Views
379
SunnyAlv
SunnyAlv

Forum statistics

Threads
1,214,853
Messages
6,121,935
Members
449,056
Latest member
denissimo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top