Is it possible to use SUMIF to allow multiple conditions? i.e. SUMIF based on criteria of >=800000 and <900000.
I have a feeling it'll be a sumproduct, right?
edit: ok it's sumproduct by the looks of it![]()
Is it possible to use SUMIF to allow multiple conditions? i.e. SUMIF based on criteria of >=800000 and <900000.
I have a feeling it'll be a sumproduct, right?
edit: ok it's sumproduct by the looks of it![]()
You can also use the sum(if function
![]()
Please Login or Register to view this content.
oh nice, that looks somewhat neater.
Learn something new every day![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks