Count formula help
 

I am trying to setup formula that does the following, What did I miss?

if data sheet,column T = k1 and data sheet, column T <=k1 and Data sheet
column B = sold and data sheet column H = *1020


=countifs(Data!T4:T261=k1,Data!T12:T261<=L1)*(Dat a!B4:B261,"sold"),(Data!H4:H227,"*1020")

Thanks for you Help!!

Count formula help
 

You arrays need to all be the same size, and you need to follow proper
function structure. Assuming you're wanting rows 4:261, corrected formula is:

=countifs(Data!T4:T261,"="&k1,Data!T4:T261,"<="&L 1,Data!B4:B261,"sold",Data!H4:H261,"*1020")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Trev" wrote:

I am trying to setup formula that does the following, What did I miss?

if data sheet,column T = k1 and data sheet, column T <=k1 and Data sheet
column B = sold and data sheet column H = *1020


=countifs(Data!T4:T261=k1,Data!T12:T261<=L1)*(Dat a!B4:B261,"sold"),(Data!H4:H227,"*1020")

Thanks for you Help!!

Count formula help
 

I have 11 entries that match Sold and 1020. 3 of them are dated 2009 and 8 of
them are dated 2009. I need to count the 2009 which my K1 cell is 1/1/09 and
L1 cell is 12/31/09. This formula is bring back a count of 8 which is the
2008 count any ideas?
Thanks

"Luke M" wrote:

You arrays need to all be the same size, and you need to follow proper
function structure. Assuming you're wanting rows 4:261, corrected formula is:

=countifs(Data!T4:T261,"="&k1,Data!T4:T261,"<="&L 1,Data!B4:B261,"sold",Data!H4:H261,"*1020")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Trev" wrote:

I am trying to setup formula that does the following, What did I miss?

if data sheet,column T = k1 and data sheet, column T <=k1 and Data sheet
column B = sold and data sheet column H = *1020


=countifs(Data!T4:T261=k1,Data!T12:T261<=L1)*(Dat a!B4:B261,"sold"),(Data!H4:H227,"*1020")

Thanks for you Help!!

Count formula help
 

I have 11 entries that match Sold and 1020. 3 of them are dated 2009 and 8
of them are dated 2008. I need to count the 2009 which my K1 cell is 1/1/09
and
L1 cell is 12/31/09. This formula is bring back a count of 8 which is the
2008 count any ideas?
Thanks

"Luke M" wrote:

You arrays need to all be the same size, and you need to follow proper
function structure. Assuming you're wanting rows 4:261, corrected formula is:

=countifs(Data!T4:T261,"="&k1,Data!T4:T261,"<="&L 1,Data!B4:B261,"sold",Data!H4:H261,"*1020")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Trev" wrote:

I am trying to setup formula that does the following, What did I miss?

if data sheet,column T = k1 and data sheet, column T <=k1 and Data sheet
column B = sold and data sheet column H = *1020


=countifs(Data!T4:T261=k1,Data!T12:T261<=L1)*(Dat a!B4:B261,"sold"),(Data!H4:H227,"*1020")

Thanks for you Help!!

Count formula help
 

Sorry Luck I had a problem in my data sheet all is well now thanks for your
help!!!
Trev

"Trev" wrote:

I have 11 entries that match Sold and 1020. 3 of them are dated 2009 and 8
of them are dated 2008. I need to count the 2009 which my K1 cell is 1/1/09
and
L1 cell is 12/31/09. This formula is bring back a count of 8 which is the
2008 count any ideas?
Thanks

"Luke M" wrote:

You arrays need to all be the same size, and you need to follow proper
function structure. Assuming you're wanting rows 4:261, corrected formula is:

=countifs(Data!T4:T261,"="&k1,Data!T4:T261,"<="&L 1,Data!B4:B261,"sold",Data!H4:H261,"*1020")

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Trev" wrote:

I am trying to setup formula that does the following, What did I miss?

if data sheet,column T = k1 and data sheet, column T <=k1 and Data sheet
column B = sold and data sheet column H = *1020


=countifs(Data!T4:T261=k1,Data!T12:T261<=L1)*(Dat a!B4:B261,"sold"),(Data!H4:H227,"*1020")

Thanks for you Help!!