I need a simple formula that will add up all the fees according to the division.
I know I can use subtotals or similar but I don't want to use it becuase it will conflict with my future demands with other formuulas.
Thanks
I need a simple formula that will add up all the fees according to the division.
I know I can use subtotals or similar but I don't want to use it becuase it will conflict with my future demands with other formuulas.
Thanks
Last edited by koklok; 10-08-2008 at 09:06 PM.
=SUMIF($D$2:$D$16,$H2,$B$2:$B$16)
copy and paste down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks