moe10134
Board Regular
- Joined
- Sep 8, 2005
- Messages
- 162
- Office Version
- 2019
- Platform
- Windows
I have a SUMIF formula created to sum hours that have the word Monday with the total for that day. The formula is not calculating any results for that total. Is there another formula I could try? Is this a worksheet issue? Protect/Not Protected? MS Excel 2003 vs MS Excel 2007? Why is the formula not erroring out? Also, if copied from a working spreadsheet into another speadsheet no data populates. This formula was created in the MS Excel 2007 version.
=SUMIF($H$39:$H$61,"Monday",$R$39:$R$61)
Any suggestions?
=SUMIF($H$39:$H$61,"Monday",$R$39:$R$61)
Any suggestions?