# sumif

#### melvinm

##### Board Regular
could you tell me what is wrong with this formula

=SUMIF(A2:A4,"=Sheet3!A1",E2:E4)
a2:a4 are dates
e2:e4 are expenses
a1 houses date as well

so lets say if I put 22/11/2005 in Sheet3 A1 its supposed to add all the expenses for 22/11/2005. as obvious there are multiple entries for each date.

thanks

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### GlennUK

##### Well-known Member
Take the quotes out, and remove the = from inside the function.

#### melvinm

##### Board Regular
thanks

Thanks a lot !!!! that worked. cheers

Replies
5
Views
115
Replies
3
Views
145
Replies
9
Views
195
Replies
1
Views
366
Replies
2
Views
345

1,195,670
Messages
6,011,074
Members
441,581
Latest member
rp4717

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