How to see if an item on one spreadsheet has been started or stopped on a different spreadsheet using countifs?

[Thomas36]

I have two spreadsheets: sheetbefore and sheetafter. on a 3rd spread i want to work out started/ stopped.

please could someone help with a formula. (a blank cell = 0)

I want to say countifs: if sheetbefore cell A2 is blank and if sheetafter cell A2 is >0
also another formula for
If sheetbefore A2 is blank and sheetafter A2 is >0


This formula isnt working=COUNTIFS('sheetbefore'!,A2,"*",'sheetafter'!,A2,">0")

Any help would be appreciated, thanks

 

[richh]

The "*" makes the if say "if A2 has anything in it, count t" and not "if A2 is blank, count it"

=COUNTIFS(sheetbefore!A2, "", sheetafter!A2,">0")

 

[Thomas36]

Thank you so much, that has worked