Is this what you want?

=SUMPRODUCT(--(E1:E100="AS FIN"),--(B1:B100="Jan"),--(H1:H100))


"anike007" wrote:

I am trying to add numbers in column H IF the data in column E=AS FIN AND the
data in column B=Jan

I've tried SUMIF, SUMPRODUCT, SUM(IF( etc.... Nothing seems to work.

Thanks for any help you can provide.