COUNTIFS and SUMIFS formula help

I have attached what I'm working on.

I need H7 to look down column A for H5, look down column B for G7 and count the incidents.

I need I7 to look down column A for H5, look down column B for G7, look down column E and add the incidents.

Originally Posted by micope21

Hi

H7

Formula:

=SUMPRODUCT((TEXT($B$5:$B$50,"mmm")=TEXT($G7,"mmm"))*(A$5:A$50=$H$5))

I7

Formula:

=SUMPRODUCT((TEXT($B$5:$B$50,"mmm")=TEXT($G7,"mmm"))*($A$5:$A$50=$H$5)*(E$5:E$50))

Regard

Thank you very much.

One more small thing. Typing a number in H5 that appears in column A will bring up that number, what do I have to do to put in a * and get all the numbers for that month?

Originally Posted by micope21

Hi.

No! It only pick up number match column A!!

If you want to know total for that month? Cell I8

Formula:

=SUMPRODUCT((TEXT($B$5:$B$50,"mmm")=TEXT($G7,"mmm"))*(E$5:E$50))

Regard

I can use that also, thank you again.