|
|
#2
01-09-2012, 01:16 AM
|
|||
|
|||
Try this:
=SUMPRODUCT(--($C$7:$C$450=X7), --($B$7:$B$450<=AC3), --($B$7:$B$450>=Z3), --($G$7:$G$450=Z6), $M$7:$M$450) That should work, if it doesn't, you're probably having a "matching" error with the dates, perhaps caused by formatting issue that AC3 and Z3 aren't the same format as you column B dates. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Replace text in multiple documents?
|
Roscoe | Word VBA | 7 | 07-31-2017 04:02 PM |
|
Displaying a date as text
|
Mandusin | Excel | 8 | 01-08-2011 02:34 AM |
|
how to center text in multiple columns
|
galiwock | Excel | 1 | 05-12-2010 09:02 AM |
| Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |
|
Multiple criteria in SUMIF?
|
pumpkin head | Excel | 1 | 02-17-2006 09:06 AM |
Windows XP 
Office 2003
Threaded Mode