Follow this topic

Last answered:

21 Sept 2023

Posted on:

21 Sept 2023

0

Different result after applying SUMIF formula

in Introduction to Excel / Use Sumif to Complete the Database Sheet

Why am I getting different result in some cells under FY16 instead of applying the same formula?

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

21 Sept 2023

0

Hi Nishita,

I believe you haven't fixed cell references properly. Please compare your formula for FY17 and FY18 with the one for FY16. Thanks!

Best,

Ned

Submit an answer

related questions

Mario Contreras

1

12

Why are we using SUMIF to transfer data instead of using VLOOKUP?

Panagiotis Blatsas

0

12

Index and Match exercise tried the exact formula yet all results are N/A?

3

10

Use Sumif to complete the dataset.

1

10

After finished this course, will i get a certificate or not?

Arowosegbe Victor Iyanuoluwa

0

10

SUMIF for Practice exam question 5

3

10

Resolved: Short cuts are different from Windows to Mac

Megburu Cynthia

0

8

I can't find the option for 'Format' after using command Ctrl + H

Zoey Iskandar Bin Fairu Zamir

0

8

Resolved: what should I do after I done my assignment?

2

8

24% of 170 Where did he get that result

1

6

Hi. Are you using some key combination to put the $ sign in your formula?

ESE CHRISTOPHER UMOEKA

0

6

Access Course Material After Completion

Kamoladdin Asatjonov

0

6

Resolved: Different result