COUNTIFS and SUMIFS formula help

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?