Dear friends,
I am using the following problem...I working on a huge spreadsheet...and I am using the funxtion countifs.
Essentially if I put figures as criteria it works...but if I put the referring cells...something goes wrong...:
ok if I write : =+SUMIFS($C$4:$C$29333,$B$4:$B$29333,">=41655.7083",$B$4:$B$29333,"<=41655.7299",$G$4:$G$29333,"=1")
but problemas if I write cells O4 by instance instead of a value such as 41655.7083...: =+SUMIFS($C$4:$C$29333,$B$4:$B$29333,">=O4 ",$B$4:$B$29333,"<= P4 ",$G$4:$G$29333,"=1")
Why?
I have to work with a lot of data...so I cannot put always the values one by one...
Could you help me please?
Sincerely
Antonio
Bookmarks