H
hal1011
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?
=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?