Count formula help

  • Thread starter Thread starter Trev
  • Start date Start date
T

Trev

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)*(Data!B4:B261,"sold"),(Data!H4:H227,"*1020")

Thanks for you 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,"<="&L1,Data!B4:B261,"sold",Data!H4:H261,"*1020")
 
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
 
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
 
Back
Top