Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
sumif function sum range
in using sumif without fixing the sum range, wouldn't that lead to wrong calclations? if other revenues appeared in the first row in the data table, then without fixing the sum range that value will be excecluded from the sum
1 answers ( 0 marked as helpful)
Hi,
In theory, yes, in this case we have to be careful not to fill in the rest of the sheet and keep the existing format the data has.
Best,
Ned
In theory, yes, in this case we have to be careful not to fill in the rest of the sheet and keep the existing format the data has.
Best,
Ned