Hi All
I have an excel sheet to calculate incomings and outgoings for a charity, in money entry I add the description and my formula, does an analasis based on a search string, the below formula is what I am using
=SUMIF(J$9:J$163,"*Raffle 0001*",F$9:F$163) Column J contains the description and column F contains the value
So my search will find all items that contain the phrase "Raffle 0001"
in column F I would have "Test Hampton Raffle (Raffle 0001)"
what I would like to add is another formula that looks for "Raffle 0001" and "Postage" but the original formula has to change to not include "Postage"
This will give me two figures for each Raffle, basically incoming and Outgoing
Bookmarks