Sumif Excel Function - multiple conditions
Closed
michaerd
Posts
1
Registration date
Friday 14 September 2012
Status
Member
Last seen
14 September 2012
-
14 Sep 2012 à 19:22
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 14 Sep 2012 à 23:53
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 14 Sep 2012 à 23:53
Related:
- Sumif Excel Function - multiple conditions
- Hard drive function - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Split excel sheet into multiple files - Guide
- Network card function - Guide
- Iserror function in excel with vlookup - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
14 Sep 2012 à 23:53
14 Sep 2012 à 23:53
=SUMPRODUCT(0+($A$1:$A$100="Technician"),0+($B$1:$B$100))+SUMPRODUCT(0+($A$1:$A$100="engineer"),($B$1:$B$100))