Hello,
I'm a bit stumped on this one. If a certain cell="all," I want another cell to display the results of
"=SUMIFS(OFFSET(FarmLog,0,4),OFFSET(FarmLog,0,1),$A$2,OFFSET(FarmLog,0,3),A9)".
If it doesn't say "all," I want
=SUMIFS(OFFSET(FarmLog,0,4),OFFSET(FarmLog,0,1),$A$2,OFFSET(FarmLog,0,2),$A$4,OFFSET(FarmLog,0,3),A9).
I thought I could use IF, but it seems that it can only return text.
Any ideas?
Thanks!
Bookmarks