How to set a condition greater than or less than a negative number?

K

K

koliaua2021-01-12 22:59:20

Google Sheets

koliaua, 2021-01-12 22:59:20

How to set a condition greater than or less than a negative number?

How to set the condition "if less than -30" in the SUMIF() formula? That is, sum up, provided that the number is less than -30
=SUMIF($V$3:$V$70,"<-30",$T$3:$T$70) tried this but does not work

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

G

galaxy, 2021-01-12
@koliaua

What doesn't work? Everything works

Similar questions

P

parvus2019-02-17 11:06:01

How to add 4 hours to a date in Google Sheets? 1Reply

S

StenMarsh13372020-11-17 12:20:27

From file to Google Sheets using Python? 1Reply

A

Aleksandr2019-02-19 14:38:21

Is it possible to pull the exchange rate of Sberbank into a Google Spreadsheet cell? 1Reply

A

Abibas882022-04-11 14:47:44

How to import cell phone contacts from google spreadsheet to android? 2Reply

A

Alex2020-11-29 22:27:29

How to add missing rows to a table? 0Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question