help with counting rows with conditions across >1 one column

[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

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A1000="X")*(B1:B1000="Y"))

 

[Guest]

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