Showing related tags and posts accross the entire site.
-
I'm sure many of you knew this but it was new to me and I came across it today, so in an effort to get it out there a bit more, i document it here. It concerns the fact that COUNTIF and SUMIF (and their 2007 plural counterparts SUMIFS and COUNTIFS) carry forward the limitation that Excel has of 15...
-
I think I understand, you can use a SUMPRODUCT for multi condition counting or summing, like so =SUMPRODUCT(--(B3:B84="V"))-SUMPRODUCT(--(R3:R84<=S3:S84))