• What's your favorite mod?

    Interested in seeing what everyone has owned/tried!

    View thread

Win Win Win! Huge 600 device Cloupor Mini Plus TC ECF giveaway!

Status
Not open for further replies.

FringeChief68

Kingsguard
ECF Veteran
Verified Member
Oct 10, 2013
14,582
77,205
Pittsburgh, Pa, USA
Lung Pong – Stop Smoking!

stop-smoking.jpg
 

v1ks_

Has a pretty generic custom title
ECF Veteran
Verified Member
Aug 18, 2015
1,768
3,851
Latvia
Umm something u enjoy

I have a strange fetish for data. I can sit for hours trying to get my excel functions right and when I do, I'm very excited. I then sit and look at all the lovely data I got from 'that wall of text' and go "Oh, oh, look at that, it's pretty!", :lol: :lol: :lol:

I'm at work... no fun today. Just some random paperwork. :D
 
  • Like
Reactions: pbanj

v1ks_

Has a pretty generic custom title
ECF Veteran
Verified Member
Aug 18, 2015
1,768
3,851
Latvia
Like, I was very excited a few days ago, when I found a way to use multiple COUNTIFS, without chaining them together with +.
Found out that I can chain them like this:
=SUM(COUNTIFS(crit_range1;{crit1;crit2};crit_range2;crit3;crit_range3;{crit4,crit5,crit6},crit_range4;crit7))

If I would write the same function by chaining COUNTIFS with +, the function would be five times longer.

I've no idea why the second multiple criteria requires me to use commas instead of semicolons, but it works! :lol:
 
  • Like
Reactions: pbanj

Midnightalaskan

Ultra Member
ECF Veteran
Aug 10, 2015
2,425
6,305
37
Folsom, CA
Like, I was very excited a few days ago, when I found a way to use multiple COUNTIFS, without chaining them together with +.
Found out that I can chain them like this:
=SUM(COUNTIFS(crit_range1;{crit1;crit2};crit_range2;crit3;crit_range3;{crit4,crit5,crit6},crit_range4;crit7))

If I would write the same function by chaining COUNTIFS with +, the function would be five times longer.

I've no idea why the second multiple criteria requires me to use commas instead of semicolons, but it works! :lol:


Hohoho! You are such a riot!
 
Status
Not open for further replies.

Users who are viewing this thread