|
|
|
|
#1
07-28-2013, 11:49 AM
|
||||
|
||||
To count the red cells ( where value is less then the preceding cell ) try
Code:
=SUMPRODUCT(--($A$1:$G$2>$B$1:$H$2))+SUMPRODUCT(--($A$1:$A$2<$B$1:$B$2)) Code:
=SUMPRODUCT(--($A$1:$G$2>$B$1:$H$2))+SUMPRODUCT(--($A$1:$A$2>$B$1:$B$2))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Counting cells with multiple complex criteria | TishyMouse | Excel | 12 | 12-06-2012 05:05 AM |
 various data needs counting
|
apples | Excel | 2 | 09-16-2012 04:52 AM |
|
Counting Colors
|
g48dd | Excel | 2 | 03-13-2011 09:28 PM |
|
Need cells to autofill with color
|
Silver Rain 007 | Excel | 1 | 10-22-2009 08:19 PM |
|
Counting Weeks
|
leroytrolley | Excel | 1 | 08-18-2008 11:12 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode