I was confused by the question. But if your answer is correct, then I think:

=IF(AND(C1=AP1,COUNTIF(M:M,"*Fee*")0),SUM(HA:HA), "")

Would be closer.

PCLIVE wrote:

One possible way if I understand you correctly:

=IF(AND(C1=AP1,COUNTIF(M:M,"Fee")0),SUM(HA:HA),"" )

"Karen Smith" wrote in message
...
I need to write a formula that does the following:

If column C = AP and somewhere in column M it says fee, then put the sum
of
column HA here.

Please note, that column M might says Agency Fee or DG Fee or System Fee
or
just Fee......but somewhere in the cells in column M the word Fee appears.
Is there a way to do this?

--

Dave Peterson