David02

New Member
Joined
Jul 10, 2019
Messages
3
Hi, I am new to this forum and currently having some problems with SUMIFS. I am trying to get the formula to check if criteria 1 and 2 are met and then if they are add the sum range value to get a total. For criteria 1 I found that the formula in G3 only notices 124 if the cell contains a letter and so the value in G3 is currently 2 but the total should be 19. Does anyone know where I might be going wrong?
ABCDEFG
1Criteria 1 rangeCriteria 2 rangeSum rangeCriteria 1124
2P124Company A2Criteria 2Company A
31246903Company A5Total=SUMIFS(C2:C5,A2:A5,"*"&G1&"*",B2:B5,G2)
4521246Company A9
5124Company A3

<tbody>
</tbody>
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Would you know if it is difficult to get this to work as well for a set range of dates. For example I set a range of dates some within June and some not, within column D and then set criteria for the end of May and start of June.

Criteria 1 rangeCriteria 2 rangeSum rangeDateCriteria 1124Criteria 331/05/2019
124Company A204/06/2019Criteria 2Company ACriteria 401/07/2019
1246903Company A520/05/2019Total19
521246Company A909/06/2019
124Company A302/07/2019

<colgroup><col span="3"><col><col span="5"><col></colgroup><tbody>
</tbody>
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,140
Members
448,551
Latest member
Sienna de Souza

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