Microsoft Office Forums - View Single Post - [Solved] Calculating the “total” based on “salary” value and its “type” (multiple IF),

Thread: [Solved] Calculating the “total” based on “salary” value and its “type” (multiple IF),

View Single Post

Old

07-04-2016, 09:54 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

As an alternative to the formula in the file 'Type Factor Value Total_2' you can use:

=SUMPRODUCT(--(G3=$B$3:$B$10),($C$3:$C$10))*F3

in row 3 and copy down.

Reply With Quote