COUNTIF or COUNT.... IF

M

MBS

Working on Sheet 2, I need to count records from Sheet1 but only want if ColA
= "text1" and ColB = "text2".

COUNTIF(('Sheet1'!A1:A10,"text1")*('Sheet1'!B1:B10,"text2"))

This is the formula I have been playing with that obviously is not working!
 
M

Marcelo

=sumproduct(--(sheet1!a1:a10="text1")*(sheet1!b1:b10="text2"))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"MBS" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate text from columns 2
using CountIF function or Array? 3
Need Help with a VBA subroutine 0
Multiple IF's with an OR 5
Excel Macro or Formula Question 1
Count Unique (30000 rows) using criteria - Please help! 13
Return match result 1
Sum of squares if condition 4

Top