Help with forumla please

[floricita]

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.

[mkvassh]

If cell B3 equal cell A2 in sheet HCA1, then give me the sum of column E in sheet HCA1

[floricita]

Thank you so much

[daddylonglegs]

Normally you would add something for when the condition is FALSE,

with just

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

If B3 is not equal to HCA1!$A$2 then the formula will return FALSE, you could make it return some text or another value or even a blank in that case, e.g. for a blank

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

put something in between the quotes for other text