Count three text values

[jmersing]

I need to count three different textvalues in the range

G11:CX298

Rover, ADDS, Dist


I was trying countif but keep getting a syntax error.

 

[macleanb]

the sumif function will do this very easily - oir you can use sumproduct. I personally find the sumif approach more "approachable" i.e. I can read the formula very easily - and my poor little brain manages to follow. The sumproduct is probably the clever and more effecient way to go - just try doing a search on sumproduct on this site and you will see lots of examples - however I suspect someone will be along shortly....

 

[jmersing]

That is not helping me, I can't find a similar example in the search results

 

[macleanb]

Hi jmersing

you can lookup the sumif function in the Excel help as this is its intended purpose and the doc will explain all. Sumproduct - well I found these which I think are what you need:


http://www.mrexcel.com/board2/viewtopic.php?t=128020&highlight=sumproduct

 

[jmersing]

ADVERTISEMENT

I tried this and it seems to work, but I'll bet there is a better way

=COUNTIF($G11:AH298,"=DIST")/4+COUNTIF($G11:AH298,"=ROVER")/4+COUNTIF($G11:AH298,"=ADDS")/4

Thanks

 

[Domenic]

Try the following array formulas that need to be confirmed with CONTROL+SHIFT+ENTER...

=SUM(COUNTIF(G11:CX298,{"Rover","ADDS","Dist"}))

OR

=SUM(COUNTIF(G11:CX298,A1:A3))

...where A1:A3 contains your 'text values'.

Hope this helps!

 

[Aladin Akyurek]

I need to count three different textvalues in the range

G11:CX298

Rover, ADDS, Dist


I was trying countif but keep getting a syntax error.

1]

=SUM(COUNTIF(G11:CX298,{"Rover","ADDS","Dist"}))

2]

=SUMPRODUCT(COUNTIF(G11:CX298,A1:A3))

where A1:A3 houses Rover, ADDS, and Dist.

 

[jmersing]

Thanks guys!

it;s working