= one total two columns different text

  • Thread starter Thread starter rtr7743
  • Start date Start date
R

rtr7743

I am trying to add a formula that will give me a total. I need it to look at
column b for Wash and then look at column h in the same row for OT and then
tell me how many have both words.
 
Try this:

=SUMPRODUCT((B1:B1000="Wash")*(H1:H1000="OT"))

I've assumed you have 1000 rows of data - adjust if you have more.

Hope this helps.

Pete
 
Back
Top