Hi all,
I'm having some trouble working through a formula that sums across specified cells with certain conditions.
For example, I have a table of fractions and would like to add everything on either side of the "/" into a total column.
So I have an series of alternating "M" and "F" variables and would like to total the "M"s as and "F" into a "Total M" and "Total F" column.
I have the beginning stages of a formula, but would need to modify it slightly as it's not working quite as accurately.
I've attached a workbook for (hopefully) further clarity.
Thank you in advance!
Darko
Bookmarks