CODEWITHSUNDEEP
excel
user3701694
user3701694

Reputation: 29

In One cell Formula is working but not in Other

I have pasted same formula in other cell. It is showing #value! Error.

=SUM(MP_Report!Z:Z,IF(MP_Report!K:K,"EPIC"))

I also tried control+shift+Enter in formula tab. It didnt work.

Please help me on this

Upvotes: 0

Views: 51

Answers (1)

CactusCake
CactusCake

Reputation: 990

Try =SUMIF(MP_Report!K:K,"EPIC",MP_Report!Z:Z)

Upvotes: 1

Related Questions