1

=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

player0
  • 124,011
  • 12
  • 67
  • 124
Michael Yanos
  • 13
  • 3
  • Then 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 – Michael Yanos Nov 24 '22 at 21:40
  • share a copy / sample of your sheet with an example of the desired output – player0 Nov 24 '22 at 21:41
  • Sheet9 Cells c:c is where I want the formula. – Michael Yanos Nov 24 '22 at 21:50

1 Answers1

0

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")))
player0
  • 124,011
  • 12
  • 67
  • 124