Good afternoon all,
I am having a problem as I modified my excel workbook and I am unable to find the sum I'm looking for. I keep getting #Value !
I have dates in cells P1 and P2, start date and end date. This is located on a sheet called Records. I have a datasheet that is full of data from 3 years on a sheet called DataBase in the same workbook.
On my worksheet called "Records" in cell N4 and O4 I have data as shown below.
I'm using this formula =SUMIFS(DataBase!H:H,DataBase!A:A,">="&$P$1,DataBase!A:A,"<="&$P$2,DataBase!S:S,O4)
Originally before I modified the page the text in O4 read "1st press". I now made a new column "N4" where I have "1st" in cell N4 and "Press" in cell O4.
How can I change this formula to have it look for N4 which will be in DataBase S:S, while also matching O4 which is located in DataBase R:R
I will be using the start date and end date as listed in the formula. I'm unsure if I need to use an "and" function or if I need to use some type of MatchIf and Sumif together. Any help would be greatly appreciated.
I am having a problem as I modified my excel workbook and I am unable to find the sum I'm looking for. I keep getting #Value !
I have dates in cells P1 and P2, start date and end date. This is located on a sheet called Records. I have a datasheet that is full of data from 3 years on a sheet called DataBase in the same workbook.
On my worksheet called "Records" in cell N4 and O4 I have data as shown below.
I'm using this formula =SUMIFS(DataBase!H:H,DataBase!A:A,">="&$P$1,DataBase!A:A,"<="&$P$2,DataBase!S:S,O4)
Originally before I modified the page the text in O4 read "1st press". I now made a new column "N4" where I have "1st" in cell N4 and "Press" in cell O4.
How can I change this formula to have it look for N4 which will be in DataBase S:S, while also matching O4 which is located in DataBase R:R
I will be using the start date and end date as listed in the formula. I'm unsure if I need to use an "and" function or if I need to use some type of MatchIf and Sumif together. Any help would be greatly appreciated.