I need a formula to create a summary sheet that can be used by lumber companies to prepare lumber of various sizes, lengths, and types of wood. Is there a better formula than =SUMIFS(A1:A100, B1:B100,B2, C1:C100, C2, F1:F100, F2)?
Blues4di
I need a formula to create a summary sheet that can be used by lumber companies to prepare lumber of various sizes, lengths, and types of wood. Is there a better formula than =SUMIFS(A1:A100, B1:B100,B2, C1:C100, C2, F1:F100, F2)?
Blues4di
Is it giving you all the right answers? Is it causing you any issues?
The formula looks OK to me. You might want to attach the file. See the yellow banner at the top of the page for instructions.
Your formula is ok.
In another way you can do this with Pivot also.
Whenever post, kindly attach sample file with required output.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
The formula does not make sense as the criteria is within the criteria range.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks