SUMIFS or other multipule criteria search

ignitebenhaigh

New Member
I'm trying to get a formula that does the following. If In column A the word is X, and in column B the date is X, sum column C? It's racking my brain

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
I'm trying to get a formula that does the following. If In column A the word is X, and in column B the date is X, sum column C? It's racking my brain

Excel 03
=SUMPRODUCT(--(\$A\$2:\$A\$15=E1),--(\$B\$2:\$B\$15=F1),\$C\$2:\$C\$15)
Excel>03
=SUMIFS(\$C\$2:\$C\$15,\$A\$2:\$A\$15,E1,\$B\$2:\$B\$15,F1)
Where E1 and F1 are your criteria(x)

Hi robert, i have excel-13 and that doesn't seem to work?

Hi robert, i have excel-13 and that doesn't seem to work?

Please use method in my signature.

Replies
1
Views
315
Replies
3
Views
1K
Replies
8
Views
228
Replies
6
Views
971
Replies
3
Views
482

1,202,987
Messages
6,052,939
Members
444,617
Latest member
Rush1984

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.

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