Eqwhipped
Whiskey is the flower of my people.
Contest,
I'm stealing this...
-
Saturday Night vHerf
5:00 PM Pacific / 8:00 Eastern! 📡 -
🔥 Light Up Your CigarPass Experience! 🔥
Get the CigarPass web app up and running in under a minute!
Dive in and unlock the full experience of the CigarPass community today!
📱 Follow the simple steps to install the app and join the community on the go!
📲 Get the App Now!Stay connected, share your passion, and never miss a puff! 💨
Sticker Pass
- Thread starter smellysell
- Start date
Most complicated thing I wrote this week. I needed to get an average of specific cells, but countif won't work because I have hidden rows and some with zeros that threw off the formula. so I sum the specific cells, then have to count indirect so I can divide and exclude zeros
=SUM(L4,L11,L14,L17,L18,L19,L22:L31)/ SUM(COUNTIF(INDIRECT({"L4","L11","L14","L17","L18","L19","L22:L31"}),"<>0"))
Eqwhipped
Whiskey is the flower of my people.
This looks like you are trying to get Excel to hack into a mainframe for espionage.Most complicated thing I wrote this week. I needed to get an average of specific cells, but countif won't work because I have hidden rows and some with zeros that threw off the formula. so I sum the specific cells, then have to count indirect so I can divide and exclude zeros
=SUM(L4,L11,L14,L17,L18,L19,L22:L31)/ SUM(COUNTIF(INDIRECT({"L4","L11","L14","L17","L18","L19","L22:L31"}),"<>0"))
Eqwhipped
Whiskey is the flower of my people.
@smellysell I will guess 21, thanks for the contest!
dawgie
I’m kind of a dumbass…
Most complicated thing I wrote this week. I needed to get an average of specific cells, but countif won't work because I have hidden rows and some with zeros that threw off the formula. so I sum the specific cells, then have to count indirect so I can divide and exclude zeros
=SUM(L4,L11,L14,L17,L18,L19,L22:L31)/ SUM(COUNTIF(INDIRECT({"L4","L11","L14","L17","L18","L19","L22:L31"}),"<>0"))
Looks like you fell asleep with your fingers on the keyboard!
.
Gavin
Well-Known Member
Shift click ftw?Most complicated thing I wrote this week. I needed to get an average of specific cells, but countif won't work because I have hidden rows and some with zeros that threw off the formula. so I sum the specific cells, then have to count indirect so I can divide and exclude zeros
=SUM(L4,L11,L14,L17,L18,L19,L22:L31)/ SUM(COUNTIF(INDIRECT({"L4","L11","L14","L17","L18","L19","L22:L31"}),"<>0"))
smellysell
Shit Bag Liberal
Last chance for contest entries
smellysell
Shit Bag Liberal
And it begins...
Eqwhipped
Whiskey is the flower of my people.
Any updates? What are we up to?