You can use the SUMPRODUCT function instead of SUMIF.
SUMPRODUCT will work on closed files.
You can use the SUMPRODUCT function instead of SUMIF.
SUMPRODUCT will work on closed files.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks