Forum Discussion
Looking for Excel Function Advise
I need some guidance on what function to use to sum of a data range for criteria contained in another data range. Down in Cell E78, I would like to count the number of adults attending a wedding ...
Hi Mark_1008,
Try this formula in cell E78:
=BYROW(TRANSPOSE((D5:D68 = TRANSPOSE(SUBSTITUTE(TEXTAFTER(B78:B81, "("), ")", ""))) * E5:E68), SUM)HTH
IlirU