Hi,
I am struggling to get SUMIF working when a any text from a set of text values are in a cell.
1.JPG
I want to write formula which
includes SUM IF based on
either iPHone or Galaxy but NOT SIM
Can you help me please I have tried many combinations but no luck.
Thanks a bunch
With your sample data in A1:B7
AND
F1: iPhone
F2: Galaxy
This regular formula returns the sum of Col_B values where the corresponding Col_A cells contain either iPhone or Galaxy
For your sample data, that formula returns: 61,782
Please Login or Register to view this content.
Is that something you can work with?
Hi inigam80
Try:
Formula:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks