Dear everyone,
I am doing sumifs formula, however, I realized that, the sum_range cannot extend across multiple columns. Is it the case or I mistaken.
If I used single column in Sum_range, the formula works well.
Thanks,
Sarin
Dear everyone,
I am doing sumifs formula, however, I realized that, the sum_range cannot extend across multiple columns. Is it the case or I mistaken.
If I used single column in Sum_range, the formula works well.
Thanks,
Sarin
hello please upload a sample file with expected results
Regards,
Jaya
You can probably use SUMPRODUCT instead.
Post your SUMIFS formula and we'll convert it to SUMPRODUCT.
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