I'm looking for a formula to give me the totals in YELLOW. I don't want to include any helper columns. thx!
I'm looking for a formula to give me the totals in YELLOW. I don't want to include any helper columns. thx!
Last edited by Xx7; 02-20-2014 at 10:24 PM.
You can use this formula in G3:
=SUMPRODUCT(--(TEXT(A$6:A$33,"mmm yyyy")&" RENT"=F3),B$6:B$33)
then copy down.
Hope this helps.
Pete
See attached
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Beauty! thanks both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks