Countif error

[mrsushi]

Hi, I have a table with with references in Column F1....F2...etc

Trying to use a countIF function to count the number of times the word "Delivered" on the sheet "Delivery status" columns F to Z. Also, need to reference the count to cell F1(Barclays) etc

So far this isnt bringing in the count.

Any ideas please?

COUNTIFS('Delivery Status'!B:B,"Barclays", 'Delivery Status'!F:Z, "Delivered")

 

[Fluff]

With countifs the ranges need to be the same size, try

=SUMPRODUCT(('Delivery Status'!$B$2:$B$1000="Barclays")*('Delivery Status'!$F$2:$Z$1000= "Delivered"))

 

[mrsushi]

With countifs the ranges need to be the same size, try

=SUMPRODUCT(('Delivery Status'!$B$2:$B$1000="Barclays")*('Delivery Status'!$F$2:$Z$1000= "Delivered"))

Many thanks for the assistance. That's work perfectly.

 

[Fluff]

You're welcome & thanks for the feedback.