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

Panagiotis Blatsas

0

12

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

Mario Contreras

1

12

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

1

10

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

3

10

Use Sumif to complete the dataset.

Arowosegbe Victor Iyanuoluwa

0

10

SUMIF for Practice exam question 5

3

10

Resolved: Short cuts are different from Windows to Mac

2

8

24% of 170 Where did he get that result

Zoey Iskandar Bin Fairu Zamir

0

8

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