Sumproduct Instead of Sumifs

[jamescooper]

Hello,

How would I turn the following formula into a Sumproduct formula instead of sumifs due to the fact the numbers are stored as text?

Thanks:

=SUMIFS('1'!$AA:$AA,'1'!$T:$T,"1",'1'!$V:$V,"EF01")

 

[gaz_chops]

Why not convert the text to numbers? Put a zero in an empty cell, Ctrl C, Highlight text, paste special, select Add, OK.

 

[gaz_chops]

For Sumproduct try

=sumproduct((1'!$T:$T="1")*('1'!$V:$V="EF01")*('1'!$AA:$AA))

 

[jamescooper]

Thanks gaz_chops!

 

[gaz_chops]

You're welcome.