hello, if anyone has few minutes to spare, i would really appreciate some help
this picture will explain what i need
\1
1st part is to sum all the values in type3 row. but the problem is how to find out all the values in type4 that have a corresponding type2 value = 8 on the same day (same column).
ty in advance
Something like this:
=SUM($B$4:$K$4)+SUMIF($B$3:$K$3;8;$B$5:$K$5)
Last edited by zbor; 10-21-2009 at 07:44 AM.
Never use Merged Cells in Excel
zbor thank You so very much, this works perfectly
can't beleive it was soo simple.
thanx again, best wishes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
MatejaBg 
Register To Reply
Bookmarks