Add two expressions ?

  • Thread starter Thread starter developer
  • Start date Start date
D

developer

Hello!

I do have this, which works just fine:

c4=COUNTIF(Sheet1!S2:S300;"Yes")

But I would like to increase the formula with also this:

(Sheet1!A2:A300;"Sweden")

So, how do I use both of them please? (&&, AND or something simula
maybe?)

Thanks a lot in advance
 
=SUMPRODUCT((Sheet1!S2:S300="Yes")*(Sheet1!A2:A300="Sweden"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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

Excel Copy COUNTIF while retaining reference 7
2 macro help 7
COUNTIF, Sorting, on Two Sheets 1
Sorting and COUNTIF 6
Fill & Drag to Right !! HELP ! 2
Help me for exact formula 2
Sumproduct using date 3
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6

Back
Top