Hi
I have this formula
Formula:=IFERROR(SUMIFS(Sheet2!$AT:$AT,Sheet2!$AP:$AP,V7,Sheet2!$AS:$AS,V5,Sheet2!$AQ:$AQ,V10),0.1)
I want it to return 0.1 if what it is looking at has no value, but it keeps returning 0.0....
What am i missing?
Dan
Hi
I have this formula
Formula:=IFERROR(SUMIFS(Sheet2!$AT:$AT,Sheet2!$AP:$AP,V7,Sheet2!$AS:$AS,V5,Sheet2!$AQ:$AQ,V10),0.1)
I want it to return 0.1 if what it is looking at has no value, but it keeps returning 0.0....
What am i missing?
Dan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks