Formula - Count scenarios

[ChrisMac1]

Hi there, happy Friday.

I am trying to work out a formula that will look at a range (rows 2 to 10000) on another sheet and count each instance where column A and B are not blank but column AG is, any easy solutions?

Many thanks,
MAC

 

[Fluff]

How about

=countifs(sheet1!a:a,"<>",sheet1!b:b,"<>",sheet1!ag:ag,"")

 

[ChrisMac1]

Hi again Fluff, thanks so much for the incredibly quick response and very useful answer, worked a treat! Have a great weekend!!!

 

[Fluff]

You're welcome & thanks for the feedback.