google sheets if and statements not workings-CodePudding

=IF(and('Form Responses 5'!BA:BA="Service/install",if('Form Responses 5'!Y:Y="V723")),sum('Form Responses 5'!Z:Z),"")

I want it so if ba:ba="service.install" then add z:z if ba:ba="sending" then add z:z

bonus if I could get it to be also included if ba:ba="receive" then subtract z:z

if none of the above, do nothing

I keep getting 'wrong number of arguments'

I've been trying for about 3 hours. I can't get it do do much. Sometimes it'll say false in the cell.

edit:

I just noticed I missed putting in half of what I wanted. I want it so if ba:ba="service.install" and y:y="V723" then add z:z if ba:ba="sending" and Y:Y="V723" then add z:z

bonus if I could get it to be also included if ba:ba="receive" then subtract z:z

if none of the above, do nothing

https://docs.google.com/spreadsheets/d/1aeckdhKBFTlaRS42wzDM1lG0CTx_ultMqjjHkRkdzYk/edit?usp=sharing

CodePudding user response：

try:

=IFERROR(SUM(FILTER('Form Responses 5'!Z:Z; REGEXMATCH(
                    'Form Responses 5'!BA:BA; "(?i)Service/install|sending");
                    'Form Responses 5'!Y:Y="V723")))