=SUMIF(D2:I2,"<>#NAME?")
lgbtq-plus
"Nine Lives ROMA" - Romulus · Quirinus
Tuesday, May 12, 2020
bigger question bopit
how does one check if a row of sells contains "EX"
you might want to have the error at the end be "ERROR"
so it returns text btw
if you sum with that
it ignores the text
=IF(D2:I2="EX", 250, 0) doesnt work :(
You know guys
https://i.imgur.com/dJ9xKxC.png
ok
so
in excel
for your error
you would do
Since I feel bad about yelling at you for 90% of my conversation in here
ctrl+shit+enter
I drew you an image
when you use the formula
which creates an array
idk if that works for sheets
This is the official art for this channel now
no its not
go away
see rusp
you can take my job
Ikr
didn't even give the bipen a tail
Look at the catfish
It’s so realistic
you've been
neutered bopit
fuck
The jews got to it
I’m sorry
that's why I have the helmet
so they don't take the one on my forehead
They’re only getting one foreskin
Better start wearing long sleeve shirts
hmmm
When all you’ve got left is 2/3
You have to protect them with your life
they'll knock it down to 3/5ths soon enough
Wait what
Oh I guess you have 1 per arm
Wait that’s still 4
2 forearms
1 forehead
1 foreskin
max
the way you wrote it
I don't think it works
can you explain what you want it to do?
im saying i want uh
to check a row
wait fuck
okay bopit whats the best way to do this
https://i.imgur.com/JfqlPqC.png
so i have this row
then a summed number
i want to find the number of EXs in this row
times that by 250
then add to the sum at the end
=sum(if(cell1 = "EX", 250, 0), if(cell2 = "EX", 250, 0), etc
is that comes to mind
=if(cell1 = "EX", 250, 0) + if(cell2 = "EX", 250, 0) + etc
is in my opinion the better way to write it
also your uh
ERROR thing isnt working in the iff
it just leaves stuff as "#name
oh
ik why
are gay
yes
yeah idk if you saw me talk about that
here are your top servants
https://i.imgur.com/2sDWwLi.png
space rin pog
why tf