Counting up

[Cmorgan]

Evening guys,

I'd appreciate any help on the following formula:

- Across rows E to Y I have a series of values (letters)

I need a formula that counts the number of times A, B or C are in the row between E to Y.

Many thanks for any help you can give.

Thanks

[simarui]

do you want a separate formula for each A, B or C? or is it a single formula that counts instances of any of the three (if so just add these three together...)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Cmorgan]

Many thanks, I have gone for

=COUNTIF(E2:Y2,"A")+COUNTIF(E2:Y2,"B")+COUNTIF(E2:Y2,"C")

Regards

[AlKey]

Try this

=SUM(COUNTIF(E2:Y2,{"A","B","C"}))