# SUM IF Formula..

#### SRIKANTHBENONI

##### New Member
Hi All,

Am facing problem with issue of Sumif formula.

I have two cols in sheet 1 ( GL and Amount ) amounts are blank.

And i have another sheet (Sheet2) and have two cols( GL and Amounts), in this sheets, the GL and amounts are multiple..

With the help of i need to pull the amounts from another sheet and it has to sum up the amounts in sheet2.

Sheet1
GL AM

123
234
345

sheet2
GL AM
123 100.00
123 100.00
234 200.00
345 300.00
345 500.00

Regards,
Sri

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Try like this

=SUMIF(Sheet2!A:A,A1,Sheet2!B:B)

Hi All,

I miss out one more thing..

even i need formula if amounts are less than "0" or >"0"

Replies
1
Views
302
Replies
5
Views
230
Replies
0
Views
301
Replies
1
Views
139
Replies
11
Views
444

1,203,686
Messages
6,056,737
Members
444,888
Latest member
Babi_mn

### 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.

### Which adblocker are you using?

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

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