asyamonique
Well-known Member
- Joined
- Jan 29, 2008
- Messages
- 1,280
- Office Version
- 2013
- Platform
- Windows
Hello, please help me with given formula below.
It doesn't give the correct results.
It should calculate the text values from named master sheet located B:F which names located at A:A
Same as on Main worksheet name located t A19 and the text value on AK5
Thanks a lot.
It doesn't give the correct results.
It should calculate the text values from named master sheet located B:F which names located at A:A
Same as on Main worksheet name located t A19 and the text value on AK5
Thanks a lot.
Excel Formula:
=SUM(IF(Master!$A:$A=Main!$A$19,IF(Master!$B:$AF=Main!$AK$5,,1)))