# COUNTIF

#### Pinaceous

##### Well-known Member
Hi All,

How would I do the following:

I have a Risk Level criteria based upon High (H), Medium (M), Low (L) that appears in Column AJ.

I have a sheet formula summing each of the criteria's corresponding values from Column F, respectfully.

For example, here is the High (H) Risk Level Formula:

Excel Formula:
``=SUMIFS(F11:F181,AJ11:AJ181,"H")``

This tells me the sum of its corresponding values from Column F that represent the (H) criteria.

So now, How can I expand upon this concept?

For example, I would like the sheet formula to count its associated value from Column F; ONLY if that row of that value is not blank for its Column B.

How would I write this sheet formula?

Thank you!
pinaceous

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

#### DanteAmor

##### Well-known Member

Excel Formula:
``=SUMIFS(F11:F181,AJ11:AJ181,"H", B11:B181,"<>")``

#### Pinaceous

##### Well-known Member
Hey DanteAmor!

Really appreciate that code!

Replies
13
Views
166
Replies
4
Views
119
Replies
5
Views
187
Replies
5
Views
96
Replies
5
Views
376

1,181,633
Messages
5,931,109
Members
436,776
Latest member
kranda

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