Calculating the “total” based on “salary” value and its “type” (multiple IF),

		Microsoft Office Forums > Microsoft Excel > Excel
Calculating the “total” based on “salary” value and its “type” (multiple IF),

FAQ

Thread Tools

Display Modes

07-04-2016, 09:54 PM

xor

Windows 10

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
How obtain accurate total of hours estimated of all subtasks that are a certain type?	pcumming	Project	3	05-14-2014 05:45 PM
VLookup formula Problem (salary plus (commission x sales))	topgear2015	Excel	11	06-05-2013 09:02 PM
Calculating a cell value based on many variables	malawimick	Excel	0	12-14-2011 05:29 PM
How do I type on multiple pics?	TimHudson	Drawing and Graphics	0	07-28-2011 10:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:17 AM.