Results 1 to 8 of 8

Sum of IF in cell N84

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-22-2012
    Location
    Czech republic
    MS-Off Ver
    Excel 2010
    Posts
    119

    Sum of IF in cell N84

    Dear all, please, I would like to simplify this formula anyhow, but I have no idea how.
    It says - =if($E8="BBS";$AL8*N8;0) and goes 60 times for each new line. I assume throuhg sumifs, it should be easier, but how? It could be done by extra sheets where "al*n" will be calculated for each month, but I do not would like to add any extra cells.
    Please help to rearange N84 (should be copy-able to P84 as well as to N85).
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1