Formula help please

[Uncle John]

I want to countif
column C is 2-Aug-04 & Column D is tp015& Column E is 23. I need to
capture this all in the same function in order to shorten time for data
entry, and it allows me to get the speciic data needed

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(C1:C100=DATE(2004,8,2)),--(D1100="tp015"),--(E1:E100=2
3))

For more about Sumproduct see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Uncle John]

Not workin thanks anyway. Keeps returning a value error

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Don Guillett]

try franks formula but refer your date to a cell instead
=SUMPRODUCT(--(C1:C100=a1),--(D1100="tp015"),--(E1:E100=23))
or
=SUMPRODUCT((C1:C100=a1)*(D1100="tp015")*(E1:E100=23))

 

[Dave Peterson]

Do you have any errors in those ranges?

Not workin thanks anyway. Keeps returning a value error

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
http://www.ozgrid.com/Services/excel-software-categories.htm **