Sumproduct & countifs

Basically, I need all instances of a word in column B (we'll go with "Create") that were done on a specific date (column A) and were done by a specific user ID (column C). I cannibalised a somewhat similar formula I used in Excel, but it's not translating across:
=SUMPRODUCT(countifs('Email Data'!$B:$B,{"Create"},'Email Data'!$A:$A,$C$1,'Email Data'!$C:$C,B35))

It's pulling across from another tab, as you can see. Cell C1 has the date required, as it's the cell for a bunch of other formulas in the page. B35 is the user ID. I have a sneaking suspicion that I'm basically there, but just missing something specific.

Any help would be appreciated.

How about

Formula:

Please Login or Register  to view this content.

I tried that one earlier. No luck.

In that case can you provide a link to your data? You will need to pu some spaces into the link as you only have 2 posts.

if you are using a date format as the countifs criteria it needs to be in quotes

Not if you are using a cell reference, as the OP is.

Thanks for that in B3 dragged down & across

Formula:

Please Login or Register  to view this content.