Thread: Countif?

I'm trying to count if there are situations where column a is equal to a specific number and column b is equal to another number.

both columns are numbers. Does anybody have a good idea how to do this, maybe countif, but i am not sure how to do more than one item with that.

Unless you have Excel 2007 (in which case you can use COUNTIFS function), try SUMPRODUCT, e.g.

=SUMPRODUCT((A1:A100=1)*(B1:B100=2))

thank you so much for the help...I tried using the $ an d commas and those messed it up.

Another similar question. I have a column of number (number of children) and a column with a month-year combination, but only in 12 out of 101 cells are there actually dates. I am wondering if there is a way to tell if there are rows with a number great than 0 in the column with numbers and a date in the column with dates.

I tried: =SUMPRODUCT((V2:V102>0)*(COUNT(E2:E102))), but it didn't work. Any ideas would be great. I am trying to do something for the place i intern where most people are computer illiterate or close to it and need a spread sheet that is easy to understand and update.

Thank you in advance and thanx again for the previous help.

Well I did and if function for every row and got that to work, then summed those to get a total. i used =IF(V2=0, 0, COUNT(E2)). This worked, but if you have an easier method maybe that would be good to know for the future.

What's in the date columns if not a date? Assuming no numbers try

=SUMPRODUCT((V2:V102>0)*ISNUMBER(E2:E102))

thanks..yes the ones without dates are just blank.