thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 1,013
- Office Version
- 365
- Platform
- Windows
Hi all,
Currently using this formula:
=SUMPRODUCT(('Helper 4'!$C:$C=B24)*'Helper 4'!$D:$D)
This is giving me a value of .25
How can I get this to roundup to 1?
Thank you in advance!
Currently using this formula:
=SUMPRODUCT(('Helper 4'!$C:$C=B24)*'Helper 4'!$D:$D)
This is giving me a value of .25
How can I get this to roundup to 1?
Thank you in advance!