help with counting rows with conditions across >1 one column

  • Thread starter Thread starter anita
  • Start date Start date
A

anita

Can anyone help me with working out a worksheet formula to
do this sum ?

For rows 1 to N)
if (columnA(rowN)= X) and (columnB(rowN)= Y) then
increment rowcount
endif
endfor

I can do it manually by nesting filters and I think what I
want to do is to be able to nest COUNTIFs but I'm having
no joy in working out the syntax for that.

Thanks
Anita
 
I'd tried to use SUMPRODUCT as shown in answers to other
posts but it didn't seem to work, however I cut/paste
your line and it works a dream. Thankyou!

Anita
 
Back
Top