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