gaj104
Well-known Member
- Joined
- Nov 9, 2002
- Messages
- 864
Hi,
I'm using a cumbersome SUMIF formula
I tried to change it to the following but it did not work
Is there a formula to simplfy the first one, mainly as I will need to add futher 3 letter criteria.
Many thanks
I'm using a cumbersome SUMIF formula
=-SUMIF(PL2006!AO:AO,"ECH",PL2006!AN:AN)-SUMIF(PL2006!AO:AO,"XCH",PL2006!AN:AN)
I tried to change it to the following but it did not work
=-SUMIF(PL2006!AO:AO,OR("ECH","XCH"),PL2006!AN:AN)
Is there a formula to simplfy the first one, mainly as I will need to add futher 3 letter criteria.
Many thanks