Please see the attached file
I want to use sumif formula with criteria in column E & Column F when I type in E, "done" and F "Vh" than some the Data of Column B.
Thanks
Kamal Singh
Please see the attached file
I want to use sumif formula with criteria in column E & Column F when I type in E, "done" and F "Vh" than some the Data of Column B.
Thanks
Kamal Singh
Using your posted file....
try this:
Copy that formula down as far as needed.Please Login or Register to view this content.
Is that something you can work with?
Another option
VBA Noob=IF(E2&F2="Wipvh","Done","Open")
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Hey man i am asking the formula "sumif" in this case....
Please help....
Sumif for Done
HTH=SUMIF(G:G,"Done",B:B)
VBA Noob
=SUMIF(G:G,"Done & Wip",B:B)
Please tell how can the above formula will be correct....
Please once more time help
Thanks
Try
Change range as required. Note Sumproduct can't work on whole column=SUMPRODUCT((E2:E4="Wip")*(G2:G4="Done")*(B2:B4))
see link for more on sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
VBA Noob
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks