Countif Formula

[DuncanGD]

I have tried a number of formulas that I have located on google without success. I am trying to create a formula that will count the cells in two columns that contain specific information.

I wish to count cells in column A that have a -1 at the end of the numbers in the cell. Eg 154879-1 and also has, in column J a text string that starts with A/C eg A/C-cmn or A/C-ah

Any help would be greatly appreciated as it will reduce my work load by 3 hours per week.

Regards

Duncan of Sydney (Aus)

[daddylonglegs]

Hello Duncan,

Try using SUMPRODUCT like this

=SUMPRODUCT(--(RIGHT(A1:A100,2)="-1"),--(LEFT(J1:J100,3)="A/C"))

[DuncanGD]

Thanks daddylonglegs.

Worked perfectly, thanks for your help