|
|
#2
01-05-2012, 06:54 PM
|
||||
|
||||
Hi Mike,
If you format your Sheet 2 cells as General, instead of Text, you could use: =SUMPRODUCT(('Sheet 1'!$C$7:$C$15=$A$3)*('Sheet 1'!$B$7:$B$15=$B$3),'Sheet 1'!J$7:J$15) This will return 0 if there are no matching 1s in column J, or a number greater than 0 otherwise (unless, perhaps, you have -ve numbers in column J).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 conditional formatting formula
|
NEHicks503 | Excel | 1 | 11-30-2011 09:01 AM |
|
IF and Conditional Formatting - Ver.2003
|
zeppelinmike | Excel | 1 | 11-13-2011 08:05 AM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode