Help with IF & AND Functions

Hello,

Im having trouble with this code, If i select multiple cells ('All Leaks'!E3:E1368) it doesn't work.

#=IF(AND('All Leaks'!E3:E1368="Meter",'All Leaks'!B871=Rates!Q337+0),1,0)#

It works when i select only a single cell ('All Leaks'!E871) but not if i have multiple cells selected

#=IF(AND('All Leaks'!E871="Meter",'All Leaks'!B871=Rates!Q337+0),1,0)#

This code's purpose is for a running total from a list, i have considered i might encounter issues relating to
more than one variable with the same output. If that was the case would i just use a sum function at
the end like this and plus one onto the original output cell?

#=IF(AND('All Leaks'!E3:E1368="Meter",'All Leaks'!B871=Rates!Q337+0),SUM(E377+1),0)#

This might be confusing but I'm really stuck, and this is my best attempt at explaining my situation,
Thank You.

(EDIT)

or to put it very simply


#=IF(E871:E873="Meter Tap",1,0)#

when i select multiple cells on an if function it doesn't work.

Thank you for your reply,

Can IF Function work with arrays?

Help2.png

So i have a list of jobs and i wish to put them in a table (IMG Below)
like this which matches the job type for example Main, Meter, Service
and also puts it in the correct cell under the date
i am adding zero to Rates"Q337 because its a date,
when i tried using the DATEVALUE function for some reason it did not work

so Rates"Q337 is a date cell.


Help.PNG

Hello Jordan and Welcome to Excel Forum.
It looks as if you are trying to count types of jobs done on a specific date which might be something that you could do using COUNTIFS. I don't understand why the orange cells have text dates as opposed to actual dates, that would make things easier. I am guessing that the orange row is 337 so, as the dates are sequential just place the date 1/10/18 in cell Q337, press Ctrl + Enter, and drag the fill handle over to cell V337.
A possible formula might be:

Formula:

=COUNTIFS('All Leaks'!$E$3:$E$1368,$P338,'All Leaks'!$B$3:$B$1368,Q$337)

If this doesn't work, I suggest uploading a SMALL desensitized/fictionalized version of the input data as well as manually mocked up output based on that data.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.