paul29berks
Active Member
- Joined
- Mar 15, 2004
- Messages
- 293
I cannot for the life of me get this formula to work
=SUMIF('Actuals 2004'!$A:$A,'Jan 2004'!$A$1&'Jan 2004'!$A$2&'Jan 2004'!$A4&'Jan 2004'!$B4&'Jan 2004'!$C4&'Jan 2004'!E3,'Actuals 2004'!$H:$H)
Actuals 2004 being where data is held. I have concatenated all fields.
Can anyone help?
Thanks
=SUMIF('Actuals 2004'!$A:$A,'Jan 2004'!$A$1&'Jan 2004'!$A$2&'Jan 2004'!$A4&'Jan 2004'!$B4&'Jan 2004'!$C4&'Jan 2004'!E3,'Actuals 2004'!$H:$H)
Actuals 2004 being where data is held. I have concatenated all fields.
Can anyone help?
Thanks