MrsFraser07
New Member
- Joined
- Aug 16, 2017
- Messages
- 44
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi everyone! This is probably simple, but it has me stumped. Any suggestions are appreciated. Here's my formula:
=SUMIFS('AccuMap Dump'!$AH$3:$AH$241,'AccuMap Dump'!$M$3:$M$241,">=$K$1",'AccuMap Dump'!$N$3:$N$241,"<5",'AccuMap Dump'!$N$3:$N$241,">0")
$K$1 is a date (value is 1/1/2023) that is calculated from another date as: =DATE(YEAR('AccuMap Dump'!M1),MONTH('AccuMap Dump'!M1),1)
What I want the SUMIFS formula to do is sum the number of wells in column AH that are greater than or equal to 1/1/2023 (date that is calculated in $K$1). The formula works if I replace $K$1 with ">=1/1/2023" but I don't want to have to manually type that in each time I change my dataset. How do I get Excel to recognize the date value in $K$1?
=SUMIFS('AccuMap Dump'!$AH$3:$AH$241,'AccuMap Dump'!$M$3:$M$241,">=$K$1",'AccuMap Dump'!$N$3:$N$241,"<5",'AccuMap Dump'!$N$3:$N$241,">0")
$K$1 is a date (value is 1/1/2023) that is calculated from another date as: =DATE(YEAR('AccuMap Dump'!M1),MONTH('AccuMap Dump'!M1),1)
What I want the SUMIFS formula to do is sum the number of wells in column AH that are greater than or equal to 1/1/2023 (date that is calculated in $K$1). The formula works if I replace $K$1 with ">=1/1/2023" but I don't want to have to manually type that in each time I change my dataset. How do I get Excel to recognize the date value in $K$1?