Hi Everyone, I been banging my head over 2 days trying to figure out how to forecast the amount of sensors.
The data I have has column B (Locations) But this location doubles up based on the different branch it has. So some location can have up to 10 entries. from C to AC are dates that each locations's branch needs more unit.
Since I have to send it to the Main location, how do I limit my countifs to just that location automatically?
I calculated the overall how much I need to send out per month using.
=COUNTIFS(Sheet4!$C:$AC,">4/1/2019", Sheet4!$C:$AC,"<4/30/2019") <-- this is an example of April.
How do I limit the count per location. Location are example ( 201,202,203,204, etc..) Do I need to add vlook up? Location are all over the cell and i would have to add it so I can't limit the range.
Also since I only need the month information is there a way to conver the 4/10/2019 to just say april 2019 and reads as April 2019? I had to do the date range because when i format the date to Apr 2019 it still has the actually date on it.
The data I have has column B (Locations) But this location doubles up based on the different branch it has. So some location can have up to 10 entries. from C to AC are dates that each locations's branch needs more unit.
Since I have to send it to the Main location, how do I limit my countifs to just that location automatically?
I calculated the overall how much I need to send out per month using.
=COUNTIFS(Sheet4!$C:$AC,">4/1/2019", Sheet4!$C:$AC,"<4/30/2019") <-- this is an example of April.
How do I limit the count per location. Location are example ( 201,202,203,204, etc..) Do I need to add vlook up? Location are all over the cell and i would have to add it so I can't limit the range.
Also since I only need the month information is there a way to conver the 4/10/2019 to just say april 2019 and reads as April 2019? I had to do the date range because when i format the date to Apr 2019 it still has the actually date on it.
