*Hi Biff
yeah you're right
So for the OP. Try:
=SUMPRODUCT(--('[Work Order Errors -
Joe.xls]John'!B5:B20000>=DATE(2004,7,1)),--('[Work Order
Errors -
Joe.xls]John'!B5:B20000<=DATE(2004,7,31)),--('[Work Order
Errors -
Joe.xls]John'!K5:K20000<>1))
This is SOOOOO close to what i need... the only issue is that i need
the formula to remove from the count any row that has a 1 in the K
column for this date range only... the problem is that there are
other date ranges, and with the formula above, it subtracts the total
number of cells with a 1 in the K column. Im trying to get totals
for MTD and the exception is that I dont want to count the cells that
have been tagged with a 1. any suggestions?
-----Original Message-----
Hi Frank!
I think he said to exclude col K if it =1.
Biff
-----Original Message-----
Hi
use
=SUMPRODUCT(--('[Work Order Errors -
Joe.xls]John'!B5:B20000>=DATE(2004,7,1)),--('[Work Order Errors -
Joe.xls]John'!B5:B20000<=DATE(2004,7,31)),--('[Work
Order
Errors -
Joe.xls]John'!K5:K20000=1))
You may take a look at:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Regards
Frank Kabel
Frankfurt, Germany
im Newsbeitrag news:three6ohchris.1b48u8@excelforum- nospam.com...
let say the workbook that i need the data to pull from is titled Work
Order Errors - joe.xls and i need to data to pull off the tab for a
person named john so it would be [Work Order Errors - Joe.xls]John
now on "johns" spreadsheet, i need to pull all of the
number or
entries
for the month of July in column B, so it would be say B5:B20000>
07/01/04 but < 07/31/04. Now to throw a loop in it, lets say that in
column K if i place a "1" there, i dont want to count this entry so
K5:K20000. I need to have a total number based off
this info. so
the
formula you gave me biff probably works, but i just
need to figure
out
how to have it pull data from another sheet....
---
Message posted
.
.
*
