SUm up issues for criteria in single column (beginner user)

heslet

New Member
Joined
Apr 5, 2024
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Sumif for criteria in one column not adding up I am just starting Excel (1 week in) and have to add these criteria. I used =countif(A15:A19,"moderatelyincreased") as the formula and got zero which it is obviously not correct. I tried =SUMIF(A15:A19,"moderatelyincreased") and failed. I am not sure if it is spacing or if I don't have the right formula, but I am clueless at this point. Can someone guide me. Greatly appreciate. This assignment is due Sunday, Lynette
1712292439323.png
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
I recommend you post your sample data using XL2BB. You're more likely to get a faster solution. Also, people can't tell from the picture which range is A15:A19.

From the surface, the criteria must match exactly as in the count range including spaces and capitalization. There's also an option to use wildcard but not sure what's the objective is until we see more.
 
Upvote 0

Forum statistics

Threads
1,223,895
Messages
6,175,257
Members
452,625
Latest member
saadat28

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