RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hello, same query but it's presented a new problem, so different thread
The following formula
Is producing an incorrect result where there isn't one:
F - Revenue Range
C - Tour Date
H - Contract Name
It compares both sheets (Just Go & Omega)
There is a countif with identical criteria, minus the F revenue range, as I need to have a count of applicable contracts and then the revenue from those contracts.
The countif returns 0, as expected, but the Sumif returns a value of £58.11
I've checked manually by making sure the Tour date in C fits within the date range, and the contract name of "Local Paper" is in column H.
There is no result, on either page, that fits those criteria.
Yet a figure is still being summed.
This happens in multiple cells on my matrix, but there are loads of correct results too.
The date range is saying where the date is greater than or equal to 01/01/2019 but less than 01/02/2019 (so, any date in January 2019)
EDIT:
As an example, in the formula given, it's looking for the Paper Name of "Local Paper"
If I isolate the formula to show just Omega, it still claims there's £58.11 of revenue
Looking into it, in Column H of Omega tab, there isn't even any instance of "Local Paper" at all...
The following formula
Code:
=SUMIFS('Just Go'!$F:$F,'Just Go'!$C:$C,">="&U$2,'Just Go'!$C:$C,"<"&W$2,'Just Go'!$H:$H,$B10)+SUMIFS(Omega!$F:$F,Omega!$C:$C,">="&U$2,Omega!$C:$C,"<"&W$2,'Just Go'!$H:$H,$B10)Is producing an incorrect result where there isn't one:
F - Revenue Range
C - Tour Date
H - Contract Name
It compares both sheets (Just Go & Omega)
There is a countif with identical criteria, minus the F revenue range, as I need to have a count of applicable contracts and then the revenue from those contracts.
The countif returns 0, as expected, but the Sumif returns a value of £58.11
I've checked manually by making sure the Tour date in C fits within the date range, and the contract name of "Local Paper" is in column H.
There is no result, on either page, that fits those criteria.
Yet a figure is still being summed.
This happens in multiple cells on my matrix, but there are loads of correct results too.
The date range is saying where the date is greater than or equal to 01/01/2019 but less than 01/02/2019 (so, any date in January 2019)
EDIT:
As an example, in the formula given, it's looking for the Paper Name of "Local Paper"
If I isolate the formula to show just Omega, it still claims there's £58.11 of revenue
Looking into it, in Column H of Omega tab, there isn't even any instance of "Local Paper" at all...
Last edited by a moderator:
