Hello I am trying to run a countif formula using two spreadsheets except i need to concatenate the criteria but I think i am missing something on my below formula. Thanks.
COUNTIFS(CONCATENATE('Daily Detail'!$B:$B,'Daily Detail'!$I:$I),CONCATENATE($A6,$C5),'Daily Detail'!$A:$A,"<>")
Last edited by ensmith; 03-06-2014 at 03:52 PM.
Not sure what your data is, but it seems like this might work for you:
Formula:
Please Login or Register to view this content.
Does it?
Yes this works thanks a lot!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks