Hello,
I am attempting to combine a sumif for a specific date (IE summing by month and another for year of the current date) and if a cell contains specific text. IE cats vs dogs where cat will be labeled as tiger and lion in the same cell. Tiger - cat, Lion - cat.
The end goal is being able to sum the total number of animals by cat or dog per month then year.
Thanks!
that is a bit of a vague description, perhaps you could upload a sample workbook representing what you have AND expected results so we can structure a formula for you.
to upload a file click go advanced under the quick reply box, then midway down click on the blue hyper link "manage attachments" then go to browse then upload and close window then submit reply to upload.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks