Eqwhipped
Whiskey is the flower of my people.
Contest,
I'm stealing this...
-
🔥 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?
smellysell
Shit Bag Liberal
He started making excuses about his stomach shrinking because he barely ate fir the 2 days prior before he even finished.
He ended ups at 16 "slices", time to go find who won.Attachments
smellysell
Shit Bag Liberal
cohibasurfer
Finally out of the darkness...
CgarDan
Well-Known Member
Great going Dawgie 
dawgie
I’m kind of a dumbass…
Holy crap!!! Thank you thank you!
.
.