par60056
Well-known Member
- Joined
- Jul 26, 2012
- Messages
- 1,581
- Office Version
- 2011
- 2010
- Platform
- Windows
- MacOS
I know this is easy and I just can't find the right way.
I want to sum J if C is not blank.
I know I can sum it is it IS blank with:
=sumif(C1:C1000,"",J1:j1000)
But I can't figure out how to specify the condition <>""
I want to sum J if C is not blank.
I know I can sum it is it IS blank with:
=sumif(C1:C1000,"",J1:j1000)
But I can't figure out how to specify the condition <>""