Need help with Function IF
Hi, I need help with the function if.
Here is what I want: I want to add the sum of the rent from the left side. Every time that the column have a "X" it should add the sum of the rent on the bottom where it's have the total. Exemple: the sum of H8 should be 2760$
Capture23.PNG
Try this formula
=SUMIF(H4:H7,"X",B4:B7)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello and welcome to the forum,
Try this :
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
It worked. Thank youOriginally Posted by AlKey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks