Need help with a SUM statement - SUMIFS?

[jlwahlen]

Hi,
I have a formula counting the # of times (on my FM Current tab) that:

Here's the FM Current tab excerpt:

Now, I would like to be able to add the column H entries that fall into the criteria I was counting above. Is there a way to do that?

 

[Fluff]

You can use SUMIFS, which is very a similar construct to the COUNTIFS.

SUMIFS Function

The Excel SUMIFS function returns the sum of cells that meet multiple conditions, referred to as criteria. To define criteria, SUMIFS supports logical operators (>,

exceljet.net

 

[jlwahlen]

You can use SUMIFS, which is very a similar construct to the COUNTIFS.

SUMIFS Function

The Excel SUMIFS function returns the sum of cells that meet multiple conditions, referred to as criteria. To define criteria, SUMIFS supports logical operators (>,

exceljet.net

that totally worked - Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.