BillieHynds
New Member
- Joined
- May 24, 2017
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi,
I am currently trying to work a SUMIFS formula looking at multiple criteria which works fine at the moment. We now have an instance where instead of summing if 1 criteria is met, I would like it to sum for 2 criteria in the same column.
=SUMIFS(Data!D:D,Data!A:A,$AO$3,Data!B:B,$AO$4,Data!C:C,$AO$2,Data!G:G,F26,Data!H:H,I26,Data!I:I,M26,Data!J:J,N26)
This is the current formula and where it says $AO$4, id like this to be $AO$4 AND $AO$5.
I've tried using using SUMPRODUCT and have not been successful.
Any help is much appreciated.
Thanks,
I am currently trying to work a SUMIFS formula looking at multiple criteria which works fine at the moment. We now have an instance where instead of summing if 1 criteria is met, I would like it to sum for 2 criteria in the same column.
=SUMIFS(Data!D:D,Data!A:A,$AO$3,Data!B:B,$AO$4,Data!C:C,$AO$2,Data!G:G,F26,Data!H:H,I26,Data!I:I,M26,Data!J:J,N26)
This is the current formula and where it says $AO$4, id like this to be $AO$4 AND $AO$5.
I've tried using using SUMPRODUCT and have not been successful.
Any help is much appreciated.
Thanks,