CountIf Function

  • Thread starter Thread starter Angela
  • Start date Start date
A

Angela

I am able to to perform a CountIf function with one
condition (i.e. If the cell equals January, count it).
But I would like the function to count when three
conditions are met (i.e. If cell one equals 'January' AND
cell two equals '2004' AND cell three equals 'Monday',
then count it). Is it possible to create this function?
Thank you!
 
Hi
use SUMPRODUCT for this. e.g.
=SUMPRODUCT(--(A1:A100="January"),--(B1:B100=2004),--(C1:C100="Monday")
)
 
You must log in or register to reply here.

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 Need Countifs Formula Help 0
using CountIF function or Array? 3
CountIf previous cell formula 0
Set non-continuous PrintArea via Function / Name 0
CountIf with And 0
Excel function - countif 2
Count range of cells if not next to each other 0
Counting only displayed cells in the column 3

Back
Top