hello wonderful experts
I am in need of some help with a count if formula and sum if formula
A,B,C,D is my data
in column "I" I need to count if column A,B,C are matching F,G,H
in column "J" I need to sum if column A,B,C are matching F,G,H
I hope my question is clear.
thank you in advance for your help
Last edited by ettenna; 10-05-2022 at 04:46 PM.
You have leading spaces in column C. Clear those (you can use the TRIM function to clean your data) then use these:
I2 =COUNTIFS(A:A,F2,B:B,G2,C:C,H2)
J2 =SUMIFS(D:D,A:A,F2,B:B,G2,C:C,H2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks