Search archive

"

is in my opinion the better way to write it

=if(cell1 = "EX", 250, 0) + if(cell2 = "EX", 250, 0) + etc

is that comes to mind

=sum(if(cell1 = "EX", 250, 0), if(cell2 = "EX", 250, 0), etc

can you explain what you want it to do?

I don't think it works

the way you wrote it

max

hmmm

so they don't take the one on my forehead

that's why I have the helmet

fuck

didn't even give the bipen a tail

idk if that works for sheets

which creates an array

when you use the formula

ctrl+shit+enter

you would do

in excel

so

ok

it ignores the text

if you sum with that

so it returns text btw

you might want to have the error at the end be "ERROR"

let me try something

might be better to have EX return 0 so it will not fuck with the sum formula

so A+++ and EX have the same value?

pog

yeah my bad I rarely use text values so I'm not used to having "

so it's retarded how it reads it

yeah it's text

I always forget the "

dumb reasons

b/c

"E"

and you need

oh

should be right let me double check

sorry about that

in front of all the letters

it put a Sheet1!D2 =

so all you need to do

I fucked up, it's =IF(Sheet1!D2 = E, 10, IF(

ok

oh wait

let me look

looks good to me

and so you can check to see that it goes to the end of the if chain