Hi
I am trying to count the number of rows which match a certain criteria.
i wanted to use =COUNTIFS(Schedule!$A$2:$A$50000,">C2",Schedule!$B$2:$B$50000,"=A320",Schedule!$C$2:$C$50000,"=LGW")
">C2" refers to a date within the sheet
the formula works if i replace the C2 with a written date i.e. 05/01/2013
what am i doing wrong here, does COUNTIFS only work with specific text fields entered within "".
whats the alternative?
many thanks
=COUNTIFS(Schedule!$A$2:$A$50000,">"&C2,Schedule!$B$2:$B$50000,A320,Schedule!$C$2:$C$50000,"LGW")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Try
=COUNTIFS(Schedule!$A$2:$A$50000,">"&C2,Schedule!$B$2:$B$50000,"A320",Schedule!$C$2:$C$50000,"LGW")
Life's a spreadsheet, Excel!
Say thanks, Click *
Try it like this:
=COUNTIFS(Schedule!$A$2:$A$50000,">"&C2,Schedule!$B$2:$B$50000,A320,Schedule!$C$2:$C$50000,"LGW")
Hope this helps.
Pete
is "A320" a cell or a value if its a value "A320" ifits a cell a320
and the rest of you were too slow lol
Ah well, we did add a bit of text in addition to the formula !!
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks