Summation scenario:
=SUMPRODUCT((A2:A145="FPG")*("B2:B145<"AER*")*(I2 :I145))

Counting scenario:
=SUMPRODUCT((A2:A145="FPG")*(B2:B145<"AER*"))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hal1011" wrote:

I am using the following formulas which work fine.

=SUMIF(B2:B145,"AER*",I2:I145)

=COUNTIF(B2:B145,"AER*")

I would like to use similar formula to sum values in Column I, if Column A
contains €œFPG€� and Column B does not contain €œAER*€�.

Also would like to use a similar formula to count values in Column B if
Column A contains €œFPG€� and Column B does not contain €œAER*€�.

Can someone help?