Add up IF/OR

[Geek Girl 007]

Hi there,
I want to add up the total of AL and Toil,
=SUM(COUNTIFS($B1:$B23),{"AL","Toil"})

I tried this but it wasn't taking it

Sorry for the screenshot, I have limited access at work.

 

[Fluff]

How about

=SUM(COUNTIFS($B1:$H23,{"AL","Toil"}))

 

[Geek Girl 007]

How about

=SUM(COUNTIFS($B1:$H23,{"AL","Toil"}))

Sorry, I meant per row, not the entire sheet.... so sorry .

 

[Fluff]

Per row, or per column?

 

[Geek Girl 007]

Per row, or per column?

Column

 

[Fluff]

In that case how about

=SUM(COUNTIFS($B1:$B23,{"AL","Toil"}))

 

[Geek Girl 007]

In that case how about

=SUM(COUNTIFS($B1:$B23,{"AL","Toil"}))

It was perfect once I took the $ out so I could pull it across for them all, however I clearly didn't state that when I asked my question.


Once again, Thanks Fluff

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Scott Huish]

Also:
=SUMPRODUCT(--(B1:B23={"AL","Toil"}))