Hi there.

I would like to understand this forumla in literal, laymen English please.

=IF(B3=HCA1!$A$2,SUM(HCA1!E:E))

Thank you.