I have added details to what im trying to accomplish on the attached doc (see both tabs). Thanks for help
I have added details to what im trying to accomplish on the attached doc (see both tabs). Thanks for help
In the green cell:
=SUMPRODUCT(('WELD DATA'!G:G=1)*('WELD DATA'!L:L=A2))
- Moo
Glad I could help, and thanks for the rep.IT WORKS!!!
- Moo
Hi awest181
Why not use the COUNTIFS as you have Excel 2010!
Formula:Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks